Hi,
You can create SSIS package as import from xls(x) within using Microsoft.ACE.OLEDB.12.0 driver.
But, if the Microsoft.ACE.OLEDB.12.0 driver inslaled on server with MSSQL, you can use the driver directly:
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0' , 'Excel 8.0;Database=\\server\file.xlsx;HDR=Yes', 'SELECT * FROM [SheetName$]')
WHERE NOT "Datum do" IS NULL
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0' , 'Excel 8.0;Database=\\server\file.xlsx;HDR=Yes', 'SELECT * FROM [SheetName$]')
SELECT '2017-01-12', '2017-01-13','AAA','BBB',30,'GJ'
UPDATE OPENROWSET('Microsoft.ACE.OLEDB.12.0' , 'Excel 8.0;Database=\\server\file.xlsx;HDR=No', 'SELECT * FROM [SheetName$A4:A4]')
SET F1=1111
MartinaJ
>Hi everybody,
>
>I'm wondering what are my options of using an SSIS package to read data from Excel without having Excel installed on the server? The package is executed as part of the job. Is there an easy way to convert Excel to csv (say, using Powershell script (but without Excel installed, so no COM automation)) or as a .NET script task?
>
>Do you have ideas?
>
>Thanks in advance.