Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 Label Options - Forms Object vs Control Box Object Awrex Excel Discussion (Misc queries) 3 July 17th 09 07:10 PM
Geeting Sheet background from Excel object model Sheela Excel Discussion (Misc queries) 3 September 4th 08 01:40 PM
VBA: Where to find Excel Object model? N. Foldager Excel Discussion (Misc queries) 13 February 6th 05 07:43 PM
"Excel.Application" Object Model Shaker Charts and Charting in Excel 2 January 9th 05 11:24 AM
Accessing the VBA project object model Tom Ogilvy Excel Programming 0 July 8th 03 02:47 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"