Export to Excel

[Brando]

Greetings,

I have an Access Report of numbers that I want to export to Excel where all sorts of great things happen to the data. When I click on "Analyze It with Microsoft Office Excel" the data ends up in a spreadsheet - all in one row.

This causes me grief in two ways: I'm exporting 280 fields (more than the number of columns in Excel), and it requires ridiculous amounts of maping.

Is there a way to export the data that keeps a table-like format?

 

[nikkypickles]

This is going to sound like a dumb question - is it a report, as in not a query?

And is it all the data that is being exported all into one row?

 

[Brando]

"Yes" to both questions. It is a report, based on a query. The report has many calulations and sums in it. Here is an example of one field:
=DCount("[No]","[qryGlobalReport]","[Type] = 'Multi-Family' And [Valuation] = 'Evaluation'")
there are lots of them like that. However, when I shorten the number of fields, it doesn't make any difference. Still just one row in Excel.

 

[gemma-the-husky]

not sure,

if you are previewing the report can you do file saveas, and save it as an excel file.

you should find it will save the underlying query, not the report as formatted which can make the excel output less useful.

 

[LostBall]

Once you have the what you want to export open, go to File, Export, and change the save as type to Microsoft Excel