This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
I am getting the following error message when trying to import data from an excel spreadsheet.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server)
I am running SSMS v20.1 on Windows 10 using a free express version of SQL. I have created a local server and the excel file is on my laptop as well. I previously had an issue with connecting to the excel file but that was resolved. Below is what I see before I get the message. The fields have self populated I have not keyed them in.
How is the issue going?
We are awaiting your reply and the latest updates at any time. If the answer solves your problem, please don't forget to 'Accept it.'
This will help others who have similar issues and assist us in closing this thread.
Apologies my son has been involved in a cycling accident and have been very busy for the past few days. Will get to this tomorrow hopefully
Too bad to hear! Anyway, no one here is requiring that you come back directly. The question in yours, and sometimes other things come in between. Higher prioritised things at work, private life or whatever. Take your time.
What other options for destinations do you have? Microsoft OLE DB Provider for SQL Server is a very old and mouldy provider, and it has no knowledge about localdb. That would explain the connection error.
Also, I know that you are running the RTM version of SQL 2017. You should download and install the last Cumulative Update for SQL 2017, which was CU31 to get access to bug fixes and improvements.
Apologies my son has been involved in a cycling accident and have been very busy for the past few days. Will get to this tomorrow hopefully
Apologies my son has been involved in a cycling accident and have been very busy for the past few days. Will get to this tomorrow hopefully
Below are all the providers I can see.
Try the one called Microsoft OLE DB Driver for SQL Server. That is the more modern MSOLEDBSQL. (And, yes, the naming is lousy.)
When I finally got to try this it worked. I downloaded the 2017 bug fix file and installed. During installation I saw a message that it could connect to the local db. I was then able to map the local server using a different connection, This then allowed me to map the excel files and they successfully imported from Excel to the SQL test database.
Thanks to all this has been a journey and I am grateful for all the help.
I suggest that you try using a regular SQL Server instance to perform data import and export.
The aforementioned blank fields being auto-populated indicate that you have successfully connected to LocalDB. Do you have to use LocalDB for development?
We are always eager to hear about the latest progress on your issue.
...........
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
2 deleted commentsComments have been turned off. Learn more