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

IMPORTING QUERIES FROM ANOTHER APP

P: n/a
Hi guys:

I am exploring the possibility of importing queries into MS-Access 2002
from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?

Thanks.
===

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Br
am*******@verizon.net wrote:
Hi guys:

I am exploring the possibility of importing queries into MS-Access
2002 from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?

Thanks.
===


Cut and paste the SQL? I don't recall any importing other than Access
objects or data sources into tables.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2

P: n/a
Thanks Bradley. I appreciate your response.

amy
==
Br@dley wrote:
am*******@verizon.net wrote:
Hi guys:

I am exploring the possibility of importing queries into MS-Access
2002 from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?

Thanks.
===


Cut and paste the SQL? I don't recall any importing other than Access
objects or data sources into tables.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response


Nov 13 '05 #3

P: n/a
Thanks Bradley. I appreciate your response.

amy
==
Br@dley wrote:
am*******@verizon.net wrote:
Hi guys:

I am exploring the possibility of importing queries into MS-Access
2002 from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?

Thanks.
===


Cut and paste the SQL? I don't recall any importing other than Access
objects or data sources into tables.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response


Nov 13 '05 #4

P: n/a
am*******@verizon.net wrote:
Hi guys:

I am exploring the possibility of importing queries into MS-Access 2002
from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?


Write code to read the file contents, create a new QueryDef and assign the SQL to the
QueryDef's .SQL property and save the query.

Should be fairly simple task.

--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #5

P: n/a
am*******@verizon.net wrote:
Hi guys:

I am exploring the possibility of importing queries into MS-Access 2002
from another app, specifically Rational Rose.

Rational can save the queries as: XML, SQL, csv, etc.

Is it possible to import queries so that they become MS-Access queries
or SQL strings in VBA?


Write code to read the file contents, create a new QueryDef and assign the SQL to the
QueryDef's .SQL property and save the query.

Should be fairly simple task.

--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.