Export access query to excel formatted

T

TheVadek

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
 
T

TheVadek

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top