Excel linked server!

[Puiu]

Im trying to make a linked server from an Excel file, but i get an error when I try to select from it:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "stanley" returned message "Unrecognized database format F:\Analiza.xls.".

I use SQLEXPRESS 2005.
It worked fine when i tryed to link to an access mdb file...
Any ideea why the database format is not recognized ?

 

[PlausiblyDamp]

Try something like

 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Analiza.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

 

[Puiu]

I had forgotten to put the provider string: Excel 8.0! Didnt realize that, sorry!
Now it works perfectly
Thank you