bulk upload excel file

Poor Pollan answered on January 4, 2023 Popularity 2/10 Helpfulness 1/10

answer bulk upload excel file

bulk upload excel file

Comment

--OPENROWSET
SELECT * 
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
   'Excel 12.0 Xml;Database=C:\data\simple.xlsx;', Sheet1$);
 
--OPENDATASOURCE
SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 
   'Data Source=C:\data\simple.xlsx;Extended Properties=EXCEL 12.0')...[Sheet1$];

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: www.mssqltips.com

Tags: bulk excel file upload whatever

Link to this answer
Share Copy Link

Contributed on Jan 04 2023

Poor Pollan

0 Answers Avg Quality 2/10

bulk upload excel file

Contents

More Related Answers

bulk upload excel file

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.