locked
Problem importing an Access Database RRS feed

  • 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

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

    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

    Sunday, August 12, 2018 3:36 PM
    Answerer
  • 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