problem with importing excel file on SSMS

noushin sharmilli 20 Reputation points
2023-03-01T19:15:48.8666667+00:00

hi,

I am trying to import a excel file to SSMS but i keep getting an error. i used both options mentioned here , the first one by going through tasks and import data but i keep getting an error. i have tried to change the microsoft ofc year to other following options available and also checked that my office version is 64 bit. i also tried through the 64 bit import wizard but it gives me error. the last 3 error messages are shown when i try through the import wizard.Screenshot (1)

Screenshot (2)

Screenshot (3)

Screenshot (4)

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,547 questions
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,922 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,781 Reputation points
    2023-03-02T01:43:30.5266667+00:00

    Hi @noushin sharmilli

    Please try to install the Microsoft.ACE.OLEDB.12.0.

    Check Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing.

    Download: https://www.microsoft.com/en-us/download/details.aspx?id=13255

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. noushin sharmilli 20 Reputation points
    2023-03-04T21:53:14.1066667+00:00

    i am having another error with one of the file i am trying to import , any idea how can i solve it. thanksScreenshot (5)