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

date format in excel imported from an SQL DB. 2
Stumped By Dates 4
Date format when exporting to Excel 3
Excel 2007 text import as text not date 3
Excel/SQL Automation help 4
Date format problems after csv import 4
Date format on cells defaulting to US instead of UK 7
UK Date Format 1

Top