Importing Data

[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?

 

[Ken Snell \(MVP\)]

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)))