Sql server 2019 import and export wizard

Naresh Koduganti 1 Reputation point
2022-08-17T07:00:18.427+00:00

I am using Sql server 2019 import and mail export wizard 64 bit to import data from excel to Sql database.

I cannot see Excel in the source selection.

I am using a 64 bit machine and my office applications are 2019 64 bit

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,556 Reputation points
    2022-08-17T07:45:58.47+00:00

    Hi @Naresh Koduganti ,

    As said in the official documentation connect-to-an-excel-data-source-sql-server-import-and-export-wizard.

    I don't see Excel in the list of data sources

    If you don't see Excel in the list of data sources, are you running the 64-bit wizard? The providers for Excel and Access are typically 32-bit and aren't visible in the 64-bit wizard. Run the 32-bit wizard instead.

    Regards,

    Zoe Hui


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