DoCmd.TransferText Import file Structure

[trihanhcie]

Hello,

I have a imported file from another application where one field is a
date.

Using DoCmd.TransferText, the structure and the data of a temptable is
created. The temptable has to be delete (data + structure) for each
import because its structure can changed following the import options.

Here is the problem :
A field date is created but if I use a english version of Windows,
then the date is not correct anymore (i m using a french version of
windows)

I would like to change the format of the date in the temptable one
it's created. How can I do it using SQL or VBA?

Thanks

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s