You are Here: FAQ Web Space & Access MSSQL Article #5

How do I import an Access database into MSSQL?

Microsoft Packages Only!
This includes:

	1&1 MS Home	1&1 Dual Standard Windows
	1&1 MS Business	1&1 Dual Unlimited Windows
	1&1 MS Business Pro	1&1 Dual Business Windows
	1&1 MS Professional

If you already have an Access database containing data that you would like to use with your 1&1 MSSQL database, follow the next steps to import your data!

Step 1:

You will first need to upload your Access database(*.mdb) file to the _db_import folder in your webspace. You can upload this file using FTP or Frontpage.

Step 2:

Log in to the 1&1 Control Panel using your Customer ID OR domain name and your password

If you have only one package, you will land on the Administration page. If you have more than one package, select the package in question to reach its Administration page.

Step 3:

Click the link for MS SQL Administration from the Domains & Web Space panel.

Step 4:

Click the Import button in the Import/Export section.

Step 5:

Select a Database name from the list that will contain the data from the import file.
arrow image

Select the File name from the drop down list, choosing the correct file for import.
arrow image

Select the Format from the drop-down list. In this case the format should be ".mdb" or "ZIP file with .mdb" if you have uploaded a zipped .mdb file.

When finished, click the Import button.

Step 6:

View the details on the confirmation page. If the details are correct, click the Import button to import the data.

Step 7:

You are taken back to the Import page. At the bottom you can view the status of any pending imports.

To check the Import status at a later time, simply click MS SQL Administration and then click the Import button to view the status on the Import page.

Print Article

Feedback

Overview	Search
Sitemap	Glossary