SQL Server Performance

Error when creating an import using import tool

Discussion in 'SQL Server DTS-Related Questions' started by bouzahme, Apr 11, 2007.

  1. bouzahme New Member

    Hi,
    I want to import an MS Access database (secured) , using the import and export tool but I have the following error message "Unexpected error occurred. The provider has returned an error result without an error message".

    Note: When I remove the password from the MS Access DB, the import work properly.

    Thanks for your Help
    bouzahme, Apr 11, 2007
    #2

  2. satya Moderator

    Yes it is due to the password on access database.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
    satya, Apr 12, 2007
    #2

  3. bouzahme New Member

    Thanks a lot.

    Ahmed
    bouzahme, Apr 12, 2007
    #2

Share This Page