Skip to content

How to Import a Large Excel into SQL Server

Prerequisite

  • SQL Server Management Studio needs to be installed on your computer

Ho-To

  1. In the Windows search bar type SQL Server 2019 Import and Export Data and use the app.

  2. Choose a Data Source
    choose-data-source.png

  3. Choose a Destination
    choose-destination.png

  4. Select "Copy data from one or more tables or views"
    copy-or-query.png

  5. Select the tables that we want to import.
    source-tables.png

  6. Run immediately
    save-and-run.png

  7. Complete
    complete.png