Error when creating an import using import tool | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error when creating an import using import tool

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
Yes it is due to the password on access database. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.
Thanks a lot. Ahmed