How to import an .xlsx file into a SQL Server database on MacOS?
How to import an .xlsx file into a SQL Server database on MacOS? 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. Overa...