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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is changing date format incorrectly 7
Vba Date$ 1
Dates in SQL query won't match 1
opening a .csv file via VB 1
CSV File - Date Formats 7
Another Question about Date Formatting 2
Date formatting in VBA 1
Problems with date formats 4

Back
Top