HowTo: Import data to SQL from password protected MDB

SQL server Mgt Studio:

  • Select DB – Right click DB – Tasks… – Import data…

=> SQL server Import Wizard opens

  • Choose a datasource – Write name – Press Advanced…

=> Datalink Properties opens.

  • Tab: “Connection”: Username: “” (Blank)
  • Tab: “Connection”: Check “Blank Password”
  • Tab: “All”: Jet OLEDB:Database Password: ******* (Enter password)
  • Tab: “Connection”: Press “Test Connection”
Advertisements

One Comment

Add yours →

  1. Thanx alot

    “Tab: “All”: Jet OLEDB:Database Password: ******* (Enter password) ”

    this is my missing step

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: