I have libreoffice 64bit and SQL Server 2019 64 bit, I would like to store query data into multiple tabs of libreoffice sheets. I know the syntax for Microsoft Excel but don’t know which driver to user to connect libreoffice to SQL Server 2019. I am looking something like this for libreoffice(below code). Please tell me the driver and correct syntax for libreoffice.
Insert into OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0’,
‘Data Source=D:\sales.xls;Extended Properties=Excel 12.0’)…[Sheet1$]
SELECT * FROM [AdventureWorksDW2012].[dbo].[DimEmployee]
Insert into OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0’,
‘Data Source=D:\sales.xls;Extended Properties=Excel 12.0’)…[Sheet2$]
SELECT * FROM [AdventureWorksDW2012].[dbo].[DimHR]