I'm trying to use the MS SQL 2008 Import and Export Data to convert an Excel spreadsheet with per minute stock data into MS SQL. One example of the time shown in the spreadsheet is '16:40' for 4:40PM.
When I get to the column mappings section of the wizard, when I change the 'type' from 'varchar' to 'time', I get an error message saying 'Found 1 unknown column type conversion(s)'.
I tried using both a csv and a text file. I tried adding seconds to the time in Excel ie 16:40:00. Neither of these debugging attempts worked.
What else should I try? For example, is there a different way to format the time in Excel which would be accepted by the export wizard?