I followed instruction to 'USING SQL SERV3ER MANAGEMNT STUDIO" to create a new link server, to store Xls to a Sql Table,

when i try to run the query i was prompted by this error:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.

here is the instruction;
1. select the OTHER DATA SOURCE option
2. in the provider list, click MICROSOFT JET 4.0 OLE DB PROVIDER
3. in the product name box type EXCEL for the name of the OLE DB DATA SOURCE
4. in the data source box, type the full path and file ame of the excel file
5. in the provider string box, type EXCEL 8.0 for an excel 2002,excel 2000 or excel 97 workbook
6 click OK

query:

SELECT * INTO tablename FROM linkservername...Sheet1$

even tried to do it using ADO and SQLOLEDB (opendatasource and openrowset over an open SQLOLEDB connection.

rgds
cyrus