Exporting from Access97 to Excel97

E

Eamonn

When exporting a query result to Excel the date field
format gets automatically changed (in some cases!) from
dd/mm/yy to mm/dd/yy. How to prevent this?

Thanks
Eamonn
 

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

VBA - exporting serial letters to single documents 0
Date Format 10
Format Excel columns with VB code. 3
Export Text: too few parameter, expected 2. 1
Exporting to a text file 1
Publisher is filling blank lines with data 2
Date Formats 4
Finding Date in an overseas format 21

Top