Linked server to Excel setting Mode property

[martynh]

I want to set up a linked server to an Excel spreadsheet. This is easy enough, except that I can't see how to set the ADO Connection object properties. In the 'Provider String' field of the linked server set up, all that seems to be read is the 'Excel x.x' value, which equates to the 'Extended Properties' property of the Connection object. Appending other properties to this (semi colon delimited) such as Mode=Read seems to be simply ignored.

If I'm correct about this, its really crap. Just like a lot to do with linked servers and ADO DB! (It's been a bad day).

Martyn
martyn.hodgson@cdesolutions.com

 

[lovalles]

i have connected sql server tables with odb, do you want to display a query on a excel sheet?