Get data from Excel, csv into SQL Server tables

Question

What is the best solution to transfer Excel and csv data from files to SQL Server tables and use trigger to automate it to other tables?

Check the following link stackoverflow.com/questions/40938557/… — Yahfoufi
– Yahfoufi, Commented Apr 13, 2019 at 8:33

Shameer Mohammed · Accepted Answer · 2019-04-13 08:03:56Z

0

The safest way would be to create an SSIS job for reading the excel/csv files run it via the Sql Server Agents. You can find details here https://learn.microsoft.com/en-us/sql/integration-services/load-data-to-from-excel-with-ssis?view=sql-server-2017

SQL statement for importing excel file

SELECT * INTO Data_dq
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
    'Excel 12.0; Database=D:\Desktop\Data.xlsx', [Data$]);

answered Apr 13, 2019 at 8:03

Shameer Mohammed

1154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1