Importing data from Excel in SQL

vincent Ewere 20

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?

Olaf Helper 44,736 Reputation points

2023-09-28T07:16:33.04+00:00

File path contains invalid Excel file.

And, have you selected a valid Excel file; means, can you open the file in Excel without any error?
vincent Ewere 20 Reputation points

2023-09-28T12:58:38.3266667+00:00

Yes I can open the document. Is an open source document. Is saved as CSV[Comma Delimited] and when you open it. At the bottom where you have sheet1 {Ready}, it say "accessibility unavailable"
HitenBhavsar-MSFT 381 Reputation points Microsoft Employee

2023-09-28T12:59:34.5033333+00:00

@vincent Ewere

Please open Excel on office outside of SSMS to make sure that Excel file valid. update us here if you see any issue or Error
vincent Ewere 20 Reputation points

2023-09-28T14:33:02.44+00:00

Yes I can open it outside SSMS but the challenge is I can't export to SQL or import from SQL
HitenBhavsar-MSFT 381 Reputation points Microsoft Employee

2023-10-17T16:03:33.0733333+00:00

HI @vincent Ewere
Just checking if there's any progress or updates?

--please don't forget to close up the thread here by marking answer if the reply is helpful--

Thank you!
Babawale Dawodu 110 Reputation points

2023-10-17T19:26:24.0333333+00:00

Try changing the file extension from .csv to .xlsx and open it. If no issues then try importing it again

Accepted answer

1 additional answer