SQL SERVER IMPORT AND EXPORT WIZARD

Mariam Wasiu 20 Reputation points
2024-04-24T13:50:36.61+00:00

I clicked on the next button to import my data from excel and it brings me this error message;

TITLE: SQL Server Import and Export Wizard

The operation could not be completed.

ADDITIONAL INFORMATION:

The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

BUTTONS:

OK

NOTE: THE DOWNLOAD LINK IS NOT WORKING

I AM STUCKED PLEASE I NEED HELP.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
Accepted answer
  1. CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
    2024-04-25T02:01:30.5466667+00:00

    Hi @Mariam Wasiu

    Please check this video: How to Fix SQL Database ODBC Driver Error.

    As a quick workaround, try save your excel file to 97-2003. Or convert it to a CSV file.

    Also, see this similar thread for more possible solutions.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest