Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Problems with Import/Export Wizard PLEASE HELP!!!

Author  Topic 

JacobPressures
Posting Yak Master

112 Posts

Posted - 2005-09-20 : 14:46:40
Guys, I'm having problems when i try to use the Import/Export wizard. When i put in that it is an MS Access document taht i'm importing from it asks for a username and password. If i put my windows authorization login and password, i get an error. if i try the suggestion of ignoring the username and password, i still get an error except it is a different one.

I have some screen shots of what happens below.



This shows what happens when i ignore the username and password adn leave it blank.

http://www.geocities.com/jacobpressures/



This shows what happens when i put in my login name and password.

http://www.geocities.com/jacobpressures/DBError2.html?1127226151449



I hear that if i used the console to run this wizard i can by pass these menus but I dont know how to use it or if it would be as easy.

Please let me know if you have any suggestions.

JacobPressures
Posting Yak Master

112 Posts

Posted - 2005-09-21 : 10:39:37
This has been resolved. The problem was that the access file was password protected. When i went ahead and removed the password everything was fine.
Go to Top of Page
   

- Advertisement -