none
Exporting wizard to sql server via odbc is not appearing RRS feed

  • Question

  • I used to export access sheet to sql server via wizard, but it is not anymore working. I have access 2016.
    Wednesday, July 5, 2017 10:12 AM

All replies

  • Hi,

    I think you now have to download a separate tool called SQL Server Migration Assistant (SSMA).

    Hope it helps...

    • Edited by .theDBguy Wednesday, July 5, 2017 2:40 PM
    Wednesday, July 5, 2017 1:24 PM
  • Hi LHannu,

    you had mentioned that it is not working.

    can you tell us what happened actually.

    did you get any error?

    try to provide steps how to reproduce your issue and how you export the data to SQL.

    when I try to use the wizard, I can able to create DSN file.

    then with the help of that DSN file you can bring that data in SQL.

    are you able to create that DSN file? what is your approach.

    let us know about that, so that we can try to provide you further suggestions to solve the issue.

    Regards

    Deepak


    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.

    Thursday, July 6, 2017 6:55 AM
    Moderator