Convert report into MS Excel Table or MS Access Table\query

[catcoota]

Hello everyone here

I wanna ask about converting report into a table! (It does not matter wether it is an Excel or Access table

I did something but It does not work fine

I opened the targeted report in preview mode and then I selected :

File---->Export ----> (file name bla bla bla ) & (Save as type MS Excel 97 - 2000)

but when i open the created file in MS Excel I get it disorganized and there is only one field , but i can't see the rest of the fields

Any help??

 

[llkhoutx]

Export the dat contained in the report, that is, the report record source , not the report itself. If you have subreports, you've got a bigger problem.

Maybe your report is ending up in one column of an Excel sheet. I've never exported a report like you're apparently saying, I export data. Yeah, I know, one has to reformat it. I've done that too.

 

[catcoota]

well, thanks 4 ur help
but i don't really understand, how to export the data source and not the data itself?

by the way, it does not have a subform, but it has a lot of calculated fields in addition to that the report has some groupings and hidden fields!

 

[llkhoutx]

Export the data, the recordsource, using the TransferSpreadsheet Action (see the Help menu). Perform you calculation in the query or in Excel after the data has been exported.