View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Vardy David Vardy is offline
external usenet poster
 
Posts: 1
Default 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