I ran into this problem a few years back. I think, maybe, possibly, the 

solution is to set up an import specification. If you do the import by 

hand, and whilst you're stepping through the Import Wizard click on the 

'Advanced...' button. in that screen you can specify the date format and 

tell Access that the date has no delimiter.



If you save the specification you can then use it in the ImportText 

method.



-BDS

Genius!

Worked great! So much sweating bullets...

Thank you, thank you!





-----Original Message-----

From: Brian Skelton [mailto:brian.skelton@b...]

Sent: Tuesday, July 10, 2001 5:44 PM

To: Access

Subject: [access] Re: Dates and Fiscal week (yyyymmdd)





I ran into this problem a few years back. I think, maybe, possibly, the

solution is to set up an import specification. If you do the import by hand,

and whilst you're stepping through the Import Wizard click on the

'Advanced...' button. in that screen you can specify the date format and

tell Access that the date has no delimiter.



If you save the specification you can then use it in the ImportText method.



-BDS