Query To String Converter

[BerkshireGuy]

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.

Anyone know of such a utility?

[Lyle Fairfield]

Re: Query To String Converter

"BerkshireG uy" <berkshireguy20 05-commerical@yaho o.comwrote in
news:1167664757 .152231.18330@h 40g2000cwb.goog legroups.com:

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.
>
Anyone know of such a utility?

The SQL created by the Query Wizard? in Access is convoluted, verbose,
inefficient, ugly and bad. (For the young: It sucks!)

One might consider going from the String to to the Stored Definition as a
more productive route. After one has learned to write SQL, many previously
puzzling tasks may seem simple.

In any case the QueryDef's SQL (string property) holds the SQL string.

--
lyle fairfield

[BerkshireGuy]

Re: Query To String Converter

Thanks Lyle:

I don't think it's clear. I know how to write SQL, but sometimes I
want to take a query and use the same logic (select statement) in VB
(perhaps in a recordset or whatever). I usually just copy and paste -
but then you need to fix all the syntax - single quote instead of
double, etc. I was wondering if there was a program that formatted a
querys SQL for VBA use.

-=B

Lyle Fairfield wrote:

"BerkshireG uy" <berkshireguy20 05-commerical@yaho o.comwrote in
news:1167664757 .152231.18330@h 40g2000cwb.goog legroups.com:
>

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.

Anyone know of such a utility?

>
The SQL created by the Query Wizard? in Access is convoluted, verbose,
inefficient, ugly and bad. (For the young: It sucks!)
>
One might consider going from the String to to the Stored Definition as a
more productive route. After one has learned to write SQL, many previously
puzzling tasks may seem simple.
>
In any case the QueryDef's SQL (string property) holds the SQL string.
>
--
lyle fairfield

[raskew via AccessMonster.com]

Re: Query To String Converter

Hi -
You might be thinking of SQL Grabber. It's freeware available at Applecore.

http://www.applecore99.com/dld/dld001.asp

HTH - Bob

BerkshireGuy wrote:

>Thanks Lyle:
>
>I don't think it's clear. I know how to write SQL, but sometimes I
>want to take a query and use the same logic (select statement) in VB
>(perhaps in a recordset or whatever). I usually just copy and paste -
>but then you need to fix all the syntax - single quote instead of
>double, etc. I was wondering if there was a program that formatted a
>querys SQL for VBA use.
>
>-=B
>

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out

>[quoted text clipped - 10 lines]

>>
>In any case the QueryDef's SQL (string property) holds the SQL string.

--
Message posted via http://www.accessmonster.com