Importing from SQL changes date format

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
 
C

Chris Nicholas

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
 

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
date format in excel imported from an SQL DB. 2
Problems with date formats 4
DateValue gets wrong date number 16

Top