Cannot use Excel source in sql import and export data

Jefferson 446 Reputation points

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

    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:


    Zoe Hui

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

    0 comments No comments