excel

  • Thread starter Thread starter bott
  • Start date Start date
B

bott

I'm trying to output the results of a query to Excel, but
with the results formatted per our needs. Any leads on how
to do this
 
I'm trying to output the results of a query to Excel, but
with the results formatted per our needs. Any leads on how
to do this
Click to expand...

Use the FOrmat() function in the query to create calculated fields, as
text strings, and export them rather than exporting the query
directly. For example, if you have a date/time field, put

ExpDate: Format([datefield], "dd-mmm-yyyy")

to get dates exported as 3-Mar-2004.
 
You must log in or register to reply here.

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

Similar Threads

Access 2003 db's & problems exporting query to Excel 1
Output query to excel 1
Dates as column names export to excel as text 5
Export query to Excel fails 6
Database Import Duplicate Issue 0
Excel solver via access/vba 1
access-excel integration 2
Transfering Data from Access Report to Excel. 2

Back
Top