Export of Date from Excel to Access

D

Daryl Hageman

I need to find a way to solve the following problem. When
the date (Short Date formated) field from Access, is
exported to Excel, it shows up in the Excel workbook as a
long date format (11/29/04 00:00). I need to find a way
to eliminate the time portion of the field.
 
J

John Nurick

Hi Daryl,

Access exports the date/time values, not the formats applied to the
fields. Just format the Excel cells the way you want them.
 

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
Exporting to Excel 0
Export Date without Time to text tab delimited file 3
Exporting table containing dates 6
Publisher is filling blank lines with data 2
Problem formatting dates from CSV file 2
Email notifications without opening application 1
Excel does not accept text format! 0

Top