'How to properly import data from an Excel file to SQL Server database? i.e. data types so that I don't get strange characters

I am trying to import an Excel file with financial data that is stored as general, text, currency, date, etc....

However, each time I select import flat file in SSMS, my data displays in the preview pane as strange characters such as below, but not only is the text showing up incorrectly, but it only shows up as 1 column. There are multiple columns in this file as listed above. How can I fix this?

Please let me know if you need additional information to help identify solutions.

enter image description here

sql-serverexcelssms


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions