Exporting date/time from Access 2002 to Excel 2002

S

Scott

After exporting date/time data from Access 2002 to Excel 2002, the field in
Excel is missing the time portion of the data. For example, "8/7/2002
11:34:46 AM" in Access becomes "8/7/2002" in Excel. This appears to happen
because Excel doesn't have a date/time data type.
 
K

Ken Snell [MVP]

Check that the cell in EXCEL isn't formatted to just show date. Normally,
the problem we see is the reverse -- exporting a date to EXCEL ends up with
the time component being shown too.
 

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

Updates for excel 2002/3 0
VBA - exporting serial letters to single documents 0
Null exported as zero 0
Exporting to Excel 0
export specific fields to Excel 2
How can I transfer data from Excel to Access dBase 1
Look Up Formula With Veried Search Range 2
Publisher is filling blank lines with data 2

Top