excel import / date format | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
excel import / date formatHi all
Got a stupid problem with the import of a date column from a excel-file to my sql-server.
The date (Month and Day) gets switched when possible. here some examples:
- 22.02.2010 -> 22.02.2010 (gets imported correct)
- 12.02.2010 -> 02.12.2010 (dd and mm are mixed up after import)
The Preview of the Excel shows the correct date. But the Preview of the SQL-Target shows already the wrong dates.
How can I fix this problem?
Any help appreciated. Thx.
I figured it out. After I have added a derived column task, where I convert the DT_DATE to DT_DBTIMESTAMP it gets imported correctly.
Good job and appreciate your feedback here again, not all enthusiastic learners like you do that… keep it up. BOL is best friend.