Unable to import excel workbook into MSSQ.

Mo 0 Reputation points
2024-04-24T12:44:49.56+00:00

I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message

User's image

here, i checked my excel version under account and it shows its 2019. here the latest version goes to 2016.

I hit next

User's image

These options show. The tutorial i was watching has a name called native server. Mine doesnt. but the last one looks the same as it shows the database name it needs to go to which is indeed spelt correct. I click next and get the below error

User's image

ADDITIONAL INFORMATION:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server)

Im a beginner so any help to fix this would be much appreciated!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,759 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2024-04-25T01:34:31.8933333+00:00

    Hi @Mo,

    If you choose run immediately and click finish, it will run the task and load data to your table, you could check the destination table.

    You may save the package to local folder or to sql server so that you can see 'it'.

    User's image Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments