Cannot use Excel source in sql import and export data

Jefferson 446 Reputation points
2023-03-31T09:15:45.4533333+00:00

There is no choice to select the Excel source in the import and export data wizard. I could use flat file source but there is no opinion for Excel....pls advi ce

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,895 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,626 Reputation points
    2023-03-31T09:21:36.58+00:00

    Hi @Jefferson,

    Please check that you are using SQL Server Import and Export Wizard 32bit or 64bit.

    Excel is a 32bit application, you may search for SQL Server Import and Export Wizard 32bit and then have a try.

    If this do not work, try to install both 32bit and 64bit for Access database engine.

    Check it out here:

    https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

    Regards´╝î

    Zoe Hui


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

    0 comments No comments