Export access query to excel formatted

[Guest]

I'm using the following code to export Access query to excel:

DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="qryexportforexcel", _
OutputFormat:=acFormatXLS, AutoStart:=False

Problem: I have a bunch of calculated currency fields they show up fine
like $5,000 in excel, but they are formatted as text in excel. So If I want
to do any calculations in excel I have to convert them in excel to numerical
column by column.

Is there a way I can export them as currency fields so I don't have to do
any conversion in excel?

Thanks

 

[Douglas J. Steele]

No, but you can always try using Automation from Excel to format the
spreadsheet once you're exported it.

I had a sample in my July, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Guest]

Thanks Doug...I was hoping I could do it straight from Access. I will give
you approach a shot.