|
-
Aug 1st, 2002, 01:30 PM
#1
Thread Starter
Lively Member
[Resolved-sort of] Import/Export/Copy a Query from one DB to another?
I resorted to a different approach eliminating the need to export the queries. Thanks!
************************************
Good afternoon,
I need to copy (or export/import) a query from one Access database to another..... I can do this with a table but unsure how to do this for a query?
Or, would you suggest that I simply rewrite the queries in VB?? One of them is VERY complicated (at least for me anyway!!) -- outer join of multiple select queries (12). Or, what do I need to look for/change if I copy the SQL statements from Access to VB to get them to work?
Either ADO or DAO is fine. Due to some time pressures I have resorted to a mixture of both (and by the way, if this will ultimately cause a problem with deployment please tell me now!!! I used DAO to import the tables, but have used ADO for the data entry portions.
Thanks,
Mary
Last edited by A441OTA; Aug 2nd, 2002 at 11:01 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|