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.
This renaming is visible when you look at Column Mapping before actually importing
And that's the point, where you can also rename then columns for import.
For renaming see Rename columns (Database Engine) - SQL Server | Microsoft Learn