April 6, 2010 at 3:28 am
The same error which earlier i described is coming.....
Big hectic for me...
April 6, 2010 at 4:02 am
chandrasekaran.ganapathy (4/6/2010)
SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', [Customers$])
Hi Here Customers$ refers the table name?
try with OPENDATASOURCE
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 10:13 pm
Insert into Table1
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\testing.xls;Extended Properties=Excel 8.0')...[sheet1$]
finally this code is working..
Thanks bhuvanesh......
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy