imported data fields are switched and unformatted

[soontobefour]

I have exported a report from Access to Excel. When I open the spreadsheet in Excel, the fields are switched and there is no formatting. I have tried to create a macro, but the data will not be in the same structure, ie: content, lines between rows, and there is a subreport on the report etc.
Is there an alternate way to accomplish this

 

[SkipVought]

Hi,

A REPORT is not a TABLE!


Either run the report from Excel or run a Data/Get External Data - Query Access from Excel


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884