SQL Server 2005 import from Excel spreadsheet does not correctly import the numeric column names
Posted on 2010-08-26
I have tried importing data from a spreadsheet to SQL Server table utilizing the standard import wizard provided in SQL Server 2005. The spreadsheet has multiple numeric column names such as 123, 145, 147 etc. The import process incorrectly names those columns as someting like F1, F2, F3 etc (depending upon the column in the spreadsheet) in the resulting imported table. Is there a way to instruct the import process to correct this issue or any workaround? This is annoying as I have to manually change those column names after every import.