import data in CSV,XML AND XLS into a table

import data in CSV,XML AND XLS into a table

XML

INSERT INTO TABLE_NAME_1 (ID,NAME)
SELECT
 C3.VALUE('ID[1]','INT') AS ID,
 C3.VALUE('NAME[1]','VARCHAR2(10)') AS NAME
 FROM
 (SELECT CAST(C1 AS XML)
 FROM OPENROWSET
 (BULK 'FILE PATH',SINGLE_BLOB) AS T1(C1))AS T2(C2)
CROSS APPLY C2.NODES('/TABLE_NAME/TABLE_NAME') T3(C3);

CSV

BULK
INSERT TABLE_NAME_1 FROM 'FILE PATH'
WITH
  ( FIELDTERMINATOR=',', FIRSTROW=2, ROWTERMINATOR='\n'
  );

XLS

INSERT INTO TABLE_NAME_1
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=FILE PATH;', 'SELECT * FROM [SHEET1$];');

Comments