RE: Access 2007 External Data Import will not recognize yyyymmdd date
- From: catkin63 <catkin63@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Aug 2008 09:07:01 -0700
Please ignore this, as I finally found my answer, after I had posted. Thank
you Klatuu for a succinct solution and Benjy for more explanation.
"catkin63" wrote:
I have been trying to import a tab-delimited .txt file that has the dates in.
a non-delimited format of yyyymmdd. I have told the wizard that the date is
in four digit years with leading zeros in YMD order with no date delimiter
and using the date datatype. I have verified that the raw data has no
additional spaces. This exact same import process worked perfectly for three
years in Access 2003, but will not work in Access 2007. One suggestion was to
go into Access Options : Advanced : General : Use four-digit year formatting
and check either This database or All databases. I chose all ... to no
effect. I have looked at some of the Q&A, but most of the answers do not
address the wizard, which has no option for CDate or DateSerial. Please help.
Thank you.
- References:
- Prev by Date: Access 2007 External Data Import will not recognize yyyymmdd date
- Next by Date: Re: Access 2007 External Data Import will not recognize yyyymmdd date
- Previous by thread: Access 2007 External Data Import will not recognize yyyymmdd date
- Next by thread: Re: Access 2007 External Data Import will not recognize yyyymmdd date
- Index(es):
Relevant Pages
|
