Guest User

Untitled

a guest
May 26th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. INSERT INTO Employee
  2. SELECT *
  3. FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
  4. 'Excel 12.0 Xml; HDR=YES; IMEX=1;
  5. Database=C:DataFilesEmployeeData1.xlsx',
  6. [vEmployee$]);
Add Comment
Please, Sign In to add comment