I've set up an SQL server using Docker on MacOS computer. I've also installed SQL Operations Studio as a GUI.
In SQL Operations Studio I'm trying to import list "Data" from a multiple-sheet AllData.xlsx file into a newly created table "Data_test" in my database "TestDB" using this chunk of code:
USE TestDB;
GO
SELECT * INTO Data_test
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0; Database=/Users/user_name/Desktop/AllData.xlsx', [Data$]);
GO
I am getting an error like this:
"The OLE DB provider "Microsoft.ACE.ODBC.12.0" has not been registered."
Is there any way to solve this issue?
A question like this has already been attempted to answer by this link. It is advised to use ODBC instead of OLEDB, but the link given in the answer refers to importing into Excel from a database, which is the opposite of what I'm trying to do.
Overall, I'm looking for some way to import .xlsx files into a SQL server databases on Mac without using Windows. I would switch from SQL Operation Studio if it solves the issue.
