Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing from SQL changes date format
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 "David Vardy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Keep Font format when importing excel into Access | Excel Discussion (Misc queries) | |||
Importing data from another spreadsheet to a different format | Excel Discussion (Misc queries) | |||
How do I change the date format when importing a txt file? | Excel Worksheet Functions | |||
importing another file format into Excel | Excel Discussion (Misc queries) |