Import from Excel sheet

[Najjar]

Hi guys,
Is there a query that allows me import
data from an Excel file.
any help will be appreciated
Thank you in advance.

[MAK]

Select * from OPENROWSET ('Microsoft.Jet.OleDB.4.0', 'EXCEL 8.0;Database=C:\MyExcel1.xls',Sheet1$)

[Najjar]

I will try it and let you know
Thank you much

[Najjar]

I get this error message.
---------
The requested properties connot be supported.
---------
what am I suppose to do for this one.

Then after that I get this error message
---------
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
---------

Thank you so much for your help.

[rmiao]

Tried this one?

Select * from OPENROWSET ('Microsoft.Jet.OleDB.4.0', 'EXCEL 8.0;Database=C:\MyExcel1.xls',[Sheet1$])

[MAK]

Select * from OPENROWSET ('Microsoft.Jet.OleDB.4.0', 'EXCEL 8.0;Database=C:\MyExcel1.xls',Sheet1$)

it works for me on both sql server 7.0 and 2000.

what version of XL sheet you are using?
What SQL Server version?

[Najjar]

I have Excel version 9.0.4402
and OLE DB version 5.00.2195.3649
and I am using MSSQL 7

I changed the statement to:

Select * from OPENROWSET ('Microsoft.Jet.OleDB.5.0', 'EXCEL 9.0;Database=C:\MyExcel1.xls',Sheet1$)

and I tried to put the full version numbers it did not work either

sometimes it imports some values but it gives me this error and it does not finish the whole table.

The error:
--------------
could not locate registry entry for OLE DB provider 'Microsoft.Jet.OleDB.5.0'
--------------

[Najjar]

Hi Guys,
Any suggestions please.

[rmiao]

Where is the excel file? On sql server's c:\ drive?

[MAK]

your Excel file should be on you server's drive.

[Najjar]

I guess I found out the problem
The Application I'm using does not allow more than 20 records to be imported
because its a trial version.
Thank you guys so much for your help.