Puiu Posted January 18, 2006 Posted January 18, 2006 I'm 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 ? Quote
Administrators PlausiblyDamp Posted January 18, 2006 Administrators Posted January 18, 2006 Try something like "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Analiza.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Puiu Posted January 19, 2006 Author Posted January 19, 2006 I had forgotten to put the provider string: Excel 8.0! Didn't realize that, sorry! Now it works perfectly Thank you Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.