SQL Import tool Fails with converted OpenOffice Documents
June 8th, 2010
The ‘SQL Server Import and Export Wizard’ can fail when trying to import a spreadsheet which was originally created by Open Office and converted by Excel into an Excel format.
Symptom
Symptoms of this problem can be seen when you edit mappings within the Wizard there are always 255 columns with the extra columns being prefixed with an ‘F’.
Even though these extra columns are not selected for import, you will get a violation of a datatype for the first column.
Solution
If this is the case, simply copy and paste the data from one document to a new blank document created by Excel.
Versions
Microsoft SQL Server Management Studio 10.0.2531.0
SQLServer 2008
Excel 2007
OpenOffice
