Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming MS Query
Is there way to
1) pass a file name (*.dqy, *.dns) to MS Query and 2) return results to Excel programmatically (without openning MS Query from Excel). Many thanks for your help (if you can help). Regards, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming MS Query
Hi Sergei,
my first reaction is why not use ADO? My second is how can you return results from MSQuery without opening MSQuery? What sort of Database are you querying? What platform/version of Excel? Do oyu have any code yet tht you can post? OJ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming MS Query
OJ, hi
Sorry I did not make myself clear. I am developing application an Excel application using VSTO 2005 & VB. NET 2005. Instead of writing a Query builder I'd like to use MS Query calling as follows i = Shell("MSQRY32.exe",...) I have experimentally figured out that I could pass a file name such as *.dqy or *.dsn, but could not find a way how to pass the results from MS Query back to my application. Thanks, "OJ" wrote: Hi Sergei, my first reaction is why not use ADO? My second is how can you return results from MSQuery without opening MSQuery? What sort of Database are you querying? What platform/version of Excel? Do oyu have any code yet tht you can post? OJ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming MS Query
If you shell it you have little chance as that will create an independent
process that you cannot access. -- HTH RP (remove nothere from the email address if mailing direct) "Sergei" wrote in message ... OJ, hi Sorry I did not make myself clear. I am developing application an Excel application using VSTO 2005 & VB. NET 2005. Instead of writing a Query builder I'd like to use MS Query calling as follows i = Shell("MSQRY32.exe",...) I have experimentally figured out that I could pass a file name such as *.dqy or *.dsn, but could not find a way how to pass the results from MS Query back to my application. Thanks, "OJ" wrote: Hi Sergei, my first reaction is why not use ADO? My second is how can you return results from MSQuery without opening MSQuery? What sort of Database are you querying? What platform/version of Excel? Do oyu have any code yet tht you can post? OJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Protecting my VBA based query programming | Excel Programming | |||
Wee programming query | Excel Programming |