Import Text File - Multiple Format Date Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing a text file with data fields of two different date field format
types. One is YYYYMM the other is YYYYMMDD. How do I tell the import spec
to accept these date field formats as date variable types?
 
YYYYMM isn't a date, so you cannot store it in a Date/Time field.

You could import your dates into a text field, add a proper date field to
the table, then write an update query to populate the date field based on
what's in the text field. For the yyyymm dates, you'll need to pick a
default day to use.
 
Back
Top