I have some incoming data stored in text files which i am trying to import into access. The date format is yyyy-mm-dd hh:mi:ss.fff eg 2002-12-15 00:00:00.000. I would like to import the date as dd/mm/yyyy without the time. I have tried many variations in the import spec but have not been able to get this to work.
Access appears not to like the fractions of a second. If i manually remove the .000 from sample data and
import that it works and is recognised as a date and i can format it in the import spec.
I would ideally like to resolve this without writing vb code or manipulating the incoming data in anyway.
Start Free Trial
