Importing Data

  • Thread starter Thread starter AJM45
  • Start date Start date
A

AJM45

I'm importing data from Excel. One column is for date but it is not formated
and is simply 20090102.

How can I import this into an Access table and convert it to a date,
01/02/2009?
 
Import the EXCEL data to a "temporary" table, then use an append query to
copy the data to the permanent table. In that append query, use a calculated
field to convert the EXCEL date value to the desired ACCESS date value.

For example:

CorrectDateValue: DateSerial(CLng(Left(ImportedDateField, 4)),
CLng(Mid(ImportedDateField, 5,2)), CLng(Right(ImportedDateField, 2)))
 
Back
Top