how to read an excel file in sql server 2000

[Amit Sk Sharma]

I tried a query SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\TestSheet.xls', 'SELECT * FROM [Sheet1$]') but its giving me error either sheet1 not found or syntax error near ')' unable to find out the base of problem. Plz suggest me the perfect query that could be able to fetch data from excel sheet. I implemented it through front end (VB.NET) and its working properly but this time i need to write a stored procedure for the same.

With Thanks & Regards Amit Sk Sharma

[Paul Conrad]

Does Sheet1 exist in the file?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus