Results 1 to 3 of 3

Thread: [Resolved-sort of] Import/Export/Copy a Query from one DB to another?

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2002
    Posts
    78

    Question [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
  •  



Click Here to Expand Forum to Full Width