Import text file with alternate date formats

[LynneAOG]

I need to import a text file with dates that are formatted as "dd-mmm-yy". If I use the Wizard, I have to go through the Advanced options to tell Access how the dates are formatted. Is there any way to bypass the Wizard and import to Access with the date specifications and a "|" as a delimiter? Thanks

 

[BattleDroid42]

You could import the text file without the defined import specification (all fields will likely default to text or number data types) and then use an append query to both format (using the Format() and CVDate()/CDate() functions; see help file for these) and append the records to your table as you want them to appear.

Cheers,
BD42

 

[PHV]

When you specify the import specifications with the wizard inside the Advanced options, simply save the schema.
Then in code you can bypass the wizard with the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244