Can Access export a report data to an editable Access table or to Excel file?

[kutlesh]

We often need to edit the data in a report, but the Access report contains formatting which interferes with data editing in Excel. Also if you try to copy the report directly from its page in Access into Excel or into Access table, it will copy formatting information.

I was wondering if I can get the data being generated in a report, but in an Access table, or an Excel file without the formatting data?

I could possibly develop macros that go step by step and execute queries which take row by row, the needed information directly into an Access table, just like in an Access report along with sorting column. But this is very slow process.

We use SAS Studio 9 instead which with few lines of code can generate the needed reports into editable Excel worksheets. But SAS Studio has expensive license.

[jdc2000]

Possibly useful links:

https://stackoverflow.com/questions/...-to-a-csv-file

http://www.databasedev.co.uk/export-macro.html

https://smallbusiness.chron.com/conv...les-40702.html