export access data to excel

L

leaf

Hello,

When I exported the data from an ACCESS database, time
6:00 was exported as 1/10/1900. What could have happened?
How to ensure proper data conversion? Also, does anyone
know how to convert data from ACCESS directly into a SAS
dataset?

Thank you and happy new year.

leaf
 

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

Macros to convert Data into date format and then plot in graph 7
export excel data to access table using ADO 0
Problems exporting database access 2000 file to dbIII format 1
Replacing a Table with a Table from another database - reference issues 1
Managing Email Thru Access 0
Exporting to Excel 0
export query result from Access 2003 to specific cells in excel 2007 5
exporting a table to SAS - date errors 1

Top