Access services question

SharePoint_Wonderings 1 Reputation point
2021-11-12T10:21:20.363+00:00

how do u import a accdb file into sql please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,499 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 20,656 Reputation points Microsoft Employee
    2021-11-15T06:34:39.673+00:00

    Hi @SharePoint_Wonderings ,

    We can use SQL Server Import and Export Wizard to import .ACCDB file to SQL server.

    1.Open MS SQL Server Import and Export Wizard.
    2.For “Data Source” choose “Microsoft Access (Microsoft.ACE.OLEDB.16.0)”. (If the data provider is not existed, please refer to this MS document to choose correct provider that corresponds to Access version)
    3.Click “Properties” enter the location of the .accdb file in the “Data Source” field. That is the physical location of the Access database file, like C:\Temp.
    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.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments