Columns formatted As Dates Are Exported as a Number to Text
 

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,

--
Rich Locus
Logicwurks, LLC

Columns formatted As Dates Are Exported as a Number to Text
 

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.
--
Rich Locus
Logicwurks, LLC


"Rich Locus" wrote:

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,

--
Rich Locus
Logicwurks, LLC