C
Chutney via AccessMonster.com
I am importing a text file that has dates in the format 15MAR06. I have the
following in my schema.ini file but the dates are not imported into the date
field in the table:
DateTimeFormat = "ddmmmyy"
I have used this successfully to import other date formats (e.g. "dd/mm/yyyy")
.. Does anyone know if/how I can import this format? I am importing to a
staging table so I can import the date to a text field and then use a formula
to move the date to the master table. However, I am interested to know if it
is possible to get the date to import correctly in one move.
Thanks and regards.
following in my schema.ini file but the dates are not imported into the date
field in the table:
DateTimeFormat = "ddmmmyy"
I have used this successfully to import other date formats (e.g. "dd/mm/yyyy")
.. Does anyone know if/how I can import this format? I am importing to a
staging table so I can import the date to a text field and then use a formula
to move the date to the master table. However, I am interested to know if it
is possible to get the date to import correctly in one move.
Thanks and regards.