Import Microsoft Access .accdb File to MS SQL Server

Mark Holmes

These steps are for exporting an .accdb file if it cannot be viewed as a table. This may be needed if the data file was generated by a Microsoft Access form. If the desired file can be viewed as a table in MS Access, then skip these steps.

  1. Open up the TechData .accdb file (not a form file).
  2. In Access 2013 in the database tools tab click the “Access Database” button under “Move Data”.
  3. Follow the wizard to split the database.
  4. Open the *_be.accdb file that was created to gain access to the database tables.

Import to MS SQL Server

  1. Open MS SQL Server Import and Export Wizard.
  2. For “Data Source” choose “Microsoft Office 12.0 Access Database Engine OLE DB Provider”.
  3. Click “Properties” enter the location of the .accdb file in the “Data Source” field.
  4. Under login information, choose a blank username and be sure to check “Blank Password”.
  5. Test the connection. If it works, click OK.
  6. For the “Data Destination” choose “Microsoft OLE DB Provider for SQL Server”.
  7. Enter the MS SQL server name or choose from the dropdown menu.
  8. Enter your SQL credentials and select the database you wish to import the data to, the database should show up in the dropdown menu if your MS SQL info is correct.
  9. Select “Copy data from one or more tables or views”.
  10. Select the tables you want copied and edit the mappings if needed.
  11. Continue through the wizard and hit finish to begin the import.

I adapted this to the MSSQL Import/Export wizard using this guide. The info for entering data at step 21 and at step 29 was particularly useful.

Last updated by on .

11 thoughts on "Import Microsoft Access .accdb File to MS SQL Server"

  1. vvv says:

    Super 🙂

  2. Valentin dangleterre says:

    Fait un topic en français fils de pute t’as crus gt bilingue, jte trouve jtenchaine ptite salope

  3. having sex says:

    we like to honor lots of other internet websites around the net, even though they arent linked to us, by linking to them. Beneath are some webpages worth checking out

  4. that could be the end of this article. Here youll find some internet sites that we think you will appreciate, just click the hyperlinks over

  5. below youll uncover the link to some websites that we feel you should visit

  6. we like to honor many other net web-sites around the net, even though they arent linked to us, by linking to them. Beneath are some webpages worth checking out

  7. below youll obtain the link to some internet sites that we believe it is best to visit

  8. that could be the end of this article. Right here youll discover some web pages that we consider youll enjoy, just click the links over

  9. below youll uncover the link to some internet sites that we consider you should visit

  10. shoe company says:

    we like to honor many other web web pages around the net, even when they arent linked to us, by linking to them. Below are some webpages worth checking out

What Are Your Thoughts?

Your email address will not be published. Required fields are marked *