Importing from SQL changes date format

  • Thread starter Thread starter David Vardy
  • Start date Start date
D

David Vardy

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
 
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
 
Back
Top