Is there a better Query than Microsoft Query

One of my favorites is Aqua Data Studio, Works really well.

http://www.aquafold.com/ <BLOCKED::http://www.aquafold.com/>

Dave Huddleston
CIO Bruewer Woodwork
Cincinnati, Ohio

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bakerprovan
Sent: Tuesday, November 07, 2006 7:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Is there a better Query than Microsoft Query



I extract data from Vantage into Excel using Microsoft Query. It
works OK as long as you keep things simple but I am getting tired of
working around the shortcomings when things get a bit more involved.
For instance you can't use outer joins when working with more than 2
tables.

Does anyone out there know of a better tool for getting the data into
excel? I am an occasional user of these features and prefer to avoid
SQL if I can.

Regards
Bob Findlay






[Non-text portions of this message have been removed]
I extract data from Vantage into Excel using Microsoft Query. It
works OK as long as you keep things simple but I am getting tired of
working around the shortcomings when things get a bit more involved.
For instance you can't use outer joins when working with more than 2
tables.

Does anyone out there know of a better tool for getting the data into
excel? I am an occasional user of these features and prefer to avoid
SQL if I can.

Regards
Bob Findlay
you can set up an ODBC connection using MS Access. Link your tables and
then create your query
there. It works pretty good.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bakerprovan
Sent: Tuesday, November 07, 2006 7:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Is there a better Query than Microsoft Query



I extract data from Vantage into Excel using Microsoft Query. It
works OK as long as you keep things simple but I am getting tired of
working around the shortcomings when things get a bit more involved.
For instance you can't use outer joins when working with more than 2
tables.

Does anyone out there know of a better tool for getting the data into
excel? I am an occasional user of these features and prefer to avoid
SQL if I can.

Regards
Bob Findlay






[Non-text portions of this message have been removed]
I use MS Access, it also has constraints when using multiple joins but
all you have to do is create multiple queries (query of a query) and the
problem is resolved.

When finished, all you need to do is create a macro that will export
your results to excel.



Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bakerprovan
Sent: Tuesday, November 07, 2006 7:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Is there a better Query than Microsoft Query



I extract data from Vantage into Excel using Microsoft Query. It
works OK as long as you keep things simple but I am getting tired of
working around the shortcomings when things get a bit more involved.
For instance you can't use outer joins when working with more than 2
tables.

Does anyone out there know of a better tool for getting the data into
excel? I am an occasional user of these features and prefer to avoid
SQL if I can.

Regards
Bob Findlay





[Non-text portions of this message have been removed]