Easier example of import of CSV XLS

SELECT * INTO   AR010207   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010207.xls ;HDR=YES;IMEX=1', [AR010207$]);

SELECT * INTO   AR010209   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010209.xls ;HDR=YES;IMEX=1', [AR010209$]);

SELECT * INTO   AR010306   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010306.xls ;HDR=YES;IMEX=1', [AR010306$]);

SELECT * INTO   AR010604   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010604.xls ;HDR=YES;IMEX=1', [AR010604$]);

SELECT * INTO   AR010605   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010605.xls ;HDR=YES;IMEX=1', [AR010605$]);

SELECT * INTO   AR010612   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010612.xls ;HDR=YES;IMEX=1', [AR010612$]);

SELECT * INTO   AR010903   FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML; Database=C:\temp\archbak\AR010903.xls ;HDR=YES;IMEX=1', [AR010903$]);