ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Does MS Query have an object model (https://www.excelbanter.com/excel-programming/271309-does-ms-query-have-object-model.html)

Frank[_12_]

Does MS Query have an object model
 
MS Query is apparently not an individual module, but is
instead used through Excel when linking to external data.
Is there an object model for MS Query just like the other
applications of MS Office?
And if so, where can documentation for it be found? Is
there perhaps a help file?

Any help will be much appreciated.


Regards,

Frank

Thomas Bartkus

Does MS Query have an object model
 
"Frank" wrote in message
...
MS Query is apparently not an individual module, but is
instead used through Excel when linking to external data.
Is there an object model for MS Query just like the other
applications of MS Office?
And if so, where can documentation for it be found? Is
there perhaps a help file?

Any help will be much appreciated.


MSQuery is much too archaic to have an object model.

The object model you want is ADO - the Microsoft ActiveX Data Objects
Library. It's picked apart on the MS website, in bocks, and if you give us
a clue or two - by many people here.

Thomas Bartkus



Frank M.

Does MS Query have an object model
 
Thanks, this was really helpful. Have found some good
articles.

Regards,

Frank M.


MSQuery is much too archaic to have an object model.

The object model you want is ADO - the Microsoft ActiveX

Data Objects
Library. It's picked apart on the MS website, in bocks,

and if you give us
a clue or two - by many people here.

Thomas Bartkus


.



All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com