How to import data from an excel file into SQL Express?

Question

Hi All!

I've been struggling a lot to import an Excel file into SQL. I installed the SQL Express version and then the SSMS.

But when I go to database>Tasks>Import data and all the rest:

Data source: Microsoft Excel

Excel file path: the path

Excel version: Microsoft Excel 2016

I get this:

Now, I've already tried going directly to SQL Server 2022 Import and Export Data (64-bit) and I get this:

When I click "OK" I get the following:

Click on "Next >"

Click on "Next >" again and I get this message:

I'm at a loss here. One of the solutions I tried was to install the 2016 Access Database Engine redistributable. But it still shows those dead ends from the images I added.

Can someone please explain to me what is wrong or how to fix this?

Also, I'm not the most tech-savvy person as I'm fairly new. Please be kind if what you explain seems a bit confusing to me at first

Answer 1

Hi @Jane Doe,

If you are using SQL Server 2022, a thread with the same error, where some users fixed the problem by uninstalling and re-installing again but some fixed through adding the SQL Server integration services to your SQL Server installation. Reference: Error with my SQL Server 2022 preview Import and Export Wizard - Microsoft Community Hub.

If this does not, please use the SQL Server Import and Export Wizard32bit for a try.

Regards，

Zoe Hui

---

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

Answer 2

Hi Jane Doe,

Maybe you are missing the AccessDatabaseEngine.

See this link for more information: https://stackoverflow.com/questions/40360932/microsoft-ace-oledb-16-0-provider-is-not-registered-on-the-local-machine-sys

Kind regards,

Wilko

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".