Okay this is getting old.

If I use the method listed before to try and query from Excel 2007 I get an error that the "Database or Object is read-only" if I run from inside our app. If I run from command window or stand alone prg it works.

So I took the code at the link and created an ADODB.Connection and ADODB.Recordset object. When I run them from the command window or a stand alone prg with just this code it works fine. If I run it from inside our application as a function call I get "Could not find instalIable ISAM" or an OLEDispatch error.

So it is our app environment. I was reading that in Sql Server you can have problems if you do not SET NOCOUNT in the Sql Server code before trying this. Is there a similar SET command in VFP I need to set? We set dozens of "SET" commands through out our app so I thought I'd ask before tracing each and every one.