Forum Discussion
Solved
Import from Excel changes Header Names
I have a wide table in Excel with column names like Q1.1, Q1.2, etc. However, when I import this table using SSMS, the column names are renamed to Q1#1#, Q1#2#, and so on. This renaming is visible w...
Could you save your Excel file as .csv file?
I tried use Import wizrd, and choose Flat file source as data source, the column names are correct.
Could you save your Excel file as .csv file?
I tried use Import wizrd, and choose Flat file source as data source, the column names are correct.