date as YYYYMMDD

  • Thread starter Thread starter dkingston
  • Start date Start date
D

dkingston

I'm importing a table to Access 2002 using ODBC and the
date field in the oringinal table is in YYYYMMDD format.
Can Access recognize this format and convert it to MMDDYY?
If so, how do I set it up?
 
Import the data into a temporary table, then use an append query that copies
the data into the permanent table. Use a calculated field similar to this
for the "date" field:

ChangeDate: CDate(Mid([DateField], 5, 2) & Right([DateField], 2) &
Mid([DateField], 3, 2)
 
Back
Top