Importing an excel file into SQL

Question

I am working though some tutorials on using SQL and I have hit a wall.

I have been using Microsoft SQL server 2022 and Management studio 19.

I have tried to import the files via the task option within the management program, but it doesn't even have the files listed (Excel or CVS) when I look through the browse option.

When I use the import and export wizard in 2022- excel file as a source and SQL Server Native Client and Microsoft OLE DB provider- I can get the file but it wont connect to the database.

Is there any work around this? I have tried pretty much all options that I have come across but i cannot seem to get past this spot

Answer 1

Hi @Daniel,

Import the files via the task option within the management program, but it doesn't even have the files listed

You may use 'import data' and then choose excel source. For csv file, you may use import flat file.

I can get the file but it wont connect to the database

Is there any error message? From my side, it works fine.

There are several ways to import data from Excel files to SQL Server.

See: Import data from Excel to SQL Server or Azure SQL Database

Regards，

Zoe Hui

---

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