Import Excel in to MSSQL does not work (use libreoffice)

Question

Hi!
I am trying to import some tables created in Libreoffice with the option to import in MSSQL.
The file is saved in .xlsx with compatibility but when trying to execute the action it gives me the following problem:

TITLE: SQL Server Import and Export Wizard

---

The operation could not be completed.

---

ADDITIONAL INFORMATION:

El proveedor 'Microsoft.ACE.OLEDB.12.0' no está registrado en el equipo local. (System.Data)

---

BUTTONS:

OK

---

After that I installed "AccessDatabaseEngine_X64" but this does not work: could it be because of the libreoffice? Is there a workaround?

Answer 1

Hi @Marcelo Lemos ,

Seems you started the SQL Server Import and Export Wizard using SSMS. Please launch the 64-bit version of the SQL Server Import and Export Wizard via the Start menu.

Check this article for more details: How to import data from an Excel file to a SQL Server database

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Marcelo Lemos ,

There are two editions of the SQL Server Import and Export Wizard: 64-bit and 32-bit.
Please make sure that you are launching a version that is matching 64-bit version of the Microsoft ACE OLEDB Provider that you installed.