By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Query To String Converter

P: n/a
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?

Jan 1 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"BerkshireGuy" <be*************************@yahoo.comwrote in
news:11*********************@h40g2000cwb.googlegro ups.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
Jan 1 '07 #2

P: n/a
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:
"BerkshireGuy" <be*************************@yahoo.comwrote in
news:11*********************@h40g2000cwb.googlegro ups.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
Jan 2 '07 #3

P: n/a
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

Jan 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.