SQL Server Performance Forum – Threads Archive

Error when creating an import using import tool

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

---

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.

---

Thanks a lot. Ahmed

---

]]>