Importing from SQL changes date format
 

We have a table with dates held as varchar data types eg
01/04/2003 which when imported using VB6 from a SQL table
appear as 04/01/2003.
The regional settings are set to UK so thats OK.
Any ideas how we stop this happening?

Thanks,

D

Importing from SQL changes date format
 

David,

I fail to see the problem that you are expressing here. The date is being
returned and formatted exactly as it should be according to the OS and
Excel. So what exactly are you wanting stopped?

Chris

"David Vardy" wrote in message
...
We have a table with dates held as varchar data types eg
01/04/2003 which when imported using VB6 from a SQL table
appear as 04/01/2003.
The regional settings are set to UK so thats OK.
Any ideas how we stop this happening?

Thanks,

D