Answered by:
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
Sunday, August 12, 2018 1:59 PM
Answers
-
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
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- Proposed as answer by Saeid Hasani Sunday, August 12, 2018 4:30 PM
- Marked as answer by BernardBouree Sunday, August 12, 2018 7:51 PM
- Unmarked as answer by BernardBouree Monday, August 13, 2018 4:00 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, February 12, 2019 7:15 AM
Sunday, August 12, 2018 3:36 PMAnswerer -
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!- Marked as answer by BernardBouree Tuesday, February 12, 2019 8:11 AM
Tuesday, February 12, 2019 7:16 AM
All replies
-
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
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- Proposed as answer by Saeid Hasani Sunday, August 12, 2018 4:30 PM
- Marked as answer by BernardBouree Sunday, August 12, 2018 7:51 PM
- Unmarked as answer by BernardBouree Monday, August 13, 2018 4:00 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, February 12, 2019 7:15 AM
Sunday, August 12, 2018 3:36 PMAnswerer -
Thanks will try to use it
Bernard Bouree
Sunday, August 12, 2018 7:51 PM -
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
Monday, August 13, 2018 12:31 PM -
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 MSDNFSF@microsoft.com.
- Edited by Teige Gao Tuesday, August 14, 2018 10:32 AM
Tuesday, August 14, 2018 10:32 AM -
Hi
I have the same error message
Bernard
Bernard Bouree
Wednesday, August 15, 2018 9:48 AM -
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
Wednesday, August 15, 2018 11:09 AM -
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!- Marked as answer by BernardBouree Tuesday, February 12, 2019 8:11 AM
Tuesday, February 12, 2019 7:16 AM