Columns formatted As Dates Are Exported as a Number to Text

R

Rich Locus

Group:
I'm sure this questions has been asked, but I didn't find it when searching
for date issues. I have a spreadsheet with a column formatted as Date. When
I save the worksheet as a text tab-delimited file, Excel converts the date
to the numeric format (i.e. 37185). Then, when I try to import the text file
into Access, Access won't accept the number as a date, and rejects every
record. Other than changing the Excel column to a Text format, is there any
other way to tell Excel to export a date formatted column with the usual
MM/DD/YYYY format instead of a number?

Thanks,
 
R

Rich Locus

Please Disregard this Question... It was my issue in that I copied a date
field "Value" using VBA into a "General Field" and it did turn it into a
number. I fixed the VBA issue.
 

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

Top