Share via

Importing data from Excel in SQL

vincent Ewere 20 Reputation points
2023-09-28T07:07:06.4+00:00

I am trying to import data from Excel into SQL using ETITLE: SQL Server Import and Export Wizard and I got below error:

File path contains invalid Excel file. Please provide file with .xls, .xlsx, .xlsm, or .xlsb extension.

What can I do to successfully import the data into SQL Management Studio?

Azure SQL Database
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 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,862 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,692 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions
Accepted answer
  1. Yitzhak Khabinsky 25,201 Reputation points
    2023-09-28T14:56:45.5833333+00:00

    Hi @vincent Ewere,

    It is a common mistake.

    Many folks are tripping on the .csv files as follows:

    • Windows file explorer doesn't show file extensions by default.
    • File icon shows that it is an Excel file.

    So, it seems that you have a .csv file "pretending" to be an MS Excel file.

    And you need to use an appropriate Import and Export Wizard options to process such file.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. vincent Ewere 20 Reputation points
    2023-10-18T06:53:15.44+00:00

    Thank you all for all your assistance. Issue resolved

    0 comments