Jitendra Patel

Jitendra Patel

  • NA
  • 149
  • 0

CVS to DB Insert

Dec 9 2011 9:23 AM
Hi All,

Problem in insert multipal record CVS to DB.
but when i insert record in my local server in below script then
it is insert perfect but when I use my db server then it is not inserted

insert INTO tbL_excel
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\pc31\C\Testexcel.xls',
'SELECT * FROM [Sheet1$]')



Answers (3)