Access 07 import yyyymmdd

T

tg

I have been trying to import a text file to access 2007 and I keep getting an
error. I looked online and noticed that it is a problem with access not
recognizing the date format yyyymmdd. In order to get around this, I have
had to import to Excel, then import the spreadsheet to access. I was hoping
someone might know a fix, or if Microsoft plans to patch this little problem.
Thanks.
 
D

Douglas J. Steele

One approach is to import the date field as Text, and then run an Update
query to convert the Text date to a real date and update a Date date field.

UPDATE MyTable
SET MyDateField = CDate(Format([MyTextDateField], "####\-##\-##"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 External Data Import will not recognize yyyymmdd date 4
Access Importing csv daily files into access 2007 1
Text File Import Fails on YYYYMMDD data field, worked great in Acc 3
Access 2007 text import specs 1
Excel date format YYYYMMDD 1
import text file yyyymmdd into date field 3
Date format on exporting query to csv file from access 2007 3
Import Excel 2010 table into Access 2010 - not listed as range 1

Top