Importing Date from CSV File

  • Thread starter Thread starter Javier
  • Start date Start date
J

Javier

Greetings,
I am linking a CSV file (comma delimited text) with a
date field in "mmddyy" format. What's the easiest way to
convert that to an ACCESS date format?

Thanks in advance.
 
I almost always take 2 steps when dealing with external data.
1. Import the data into Access into a "staging" table using any means
possible.
(In your case import mmddyy as Text.)

2. Write an Append query and transform any "bad" data in the process.
i.e. create a real date out of the pieces of your text data.
(Check out DateSerial in Help.)

' Return a date.
MyDate = DateSerial(1969, 2, 12)
 
Back
Top