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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply