Problem importing an Access Database

Question

Hi

I'm trying to import an Access Database in an SQL one.

I used SQL Server Management Studio.

I created a new database then Tasks / Import Data /  Microsoft Access / my file.mdb

But I got this error:

The ConnectionString is not initialised (System.Data)

What I'm doing wrong ? The ConnectionString is defined by defaut at "Dsn"

Thanks

Bernard

---

Bernard Bouree

Answer 1

what is the datasource you used?

Since you're trying to connect using DSN you should be using .Net provider for odbc as shown

Then specify the DSN name in the properties and try to connect

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-an-odbc-data-source-sql-server-import-and-export-wizard?view=sql-server-2017

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 2

Thanks will try to use it

---

Bernard Bouree

Answer 3

Hi

I have followed the link provided and get the following error

ERROR [IM010] [Microsoft][Gestionnaire de pilotes ODBC] Source Name is too long!

Dsn={Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\Users\berna\OneDrive\Documents\Généalogie\Toponymes\GeoDB.mdb;Mode=12}

It is strange since I'm using it in an other application.

Thanks for your help.

Bernard

---

Bernard Bouree

Answer 4

Hi BernardBouree,

What about using the driver DRIVER={Microsoft Access Driver (*.mdb)?

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 5

Hi

I have the same error message 

Bernard

---

Bernard Bouree

Answer 6

Hi

I went through the MS help documentation.

I need to connect with a mdb data base.

I understand that I need to find the source "Microsoft Access (Microsoft.ACE.OLEDB.15.0)" for Office 2013. 

I then donwloaded AccessDatabaseEngine.exe, run it with the /quiet option in order to overcome the error message linked to "Click to run".

Then I'm not sure it was installed correctly since it does not appears in the sources.

Thanks for your help

Bernard

 

---

Bernard Bouree

Answer 7

Hi

I went through the MS help documentation.

I need to connect with a mdb data base.

I understand that I need to find the source "Microsoft Access (Microsoft.ACE.OLEDB.15.0)" for Office 2013. 

I then donwloaded AccessDatabaseEngine.exe, run it with the /quiet option in order to overcome the error message linked to "Click to run".

Then I'm not sure it was installed correctly since it does not appears in the sources.

Thanks for your help

Bernard

 

---

Bernard Bouree

Bernard, do you have an update on this issue?

Thanks!

---

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!