I am trying to import an Excel file into a SQL Server database in Microsoft SQL Server Management Studio.
When I click the SQL Server Import and Export wizard server import and export wizard
this error happens:
Do you know what can lead to that?
I looked for this error in Microsoft website and other places and I saw that I need to change the authentication to - Windows authentication in the SQL Server connection.
I did it but the authentication was already set to Windows authentication
1条答案
按热度按时间piok6c0g1#
Excel can have all kinds of weird formatting that throws things off during the import process. You should save your Excel file as a CSV file, and import the CSV.
Or, if you are open to a VBA solution to move data from your Excel file to your SQL Server database, run the code below.
Or, simply run the code below in SQL Server.