Insert Local Excel data sheet into SQL(remote) Server

• mahalirajesh

  SSC Enthusiast

  Points: 197

  More actions

  March 10, 2010 at 11:28 pm

  #219786

  insert INTO tbL_excel

  SELECT *

  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=\\pc31\C\Testexcel.xls',

  'SELECT * FROM [Sheet1$]')

  anybody help me solve this.

  Local Excel sheet to SQL(Remote) Server

  Rajesh