Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    4

    Thumbs down Unanswered: Move Query from DB to DB?

    Hello,

    I am trying to use visual basic to move a Crosstab Query from one mdb to another mdb.

    (I'm ussing Access 97 and vb6)

    How can I do this using ADO, or some other method? I don't think it is possible with SQL...

    Or, is there a way to move the DATA that is currently in one Crosstab Query into another Crosstab Query in a different mdb (they both have the same structure)?

    Any help would be GREATLY appreciated. This is NOT for a school class.

    Thanks again!

    Brian

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    How are you storing the results of the crosstab query within vb ?

  3. #3
    Join Date
    Nov 2002
    Posts
    4

    Hmm..

    Originally posted by rnealejr
    How are you storing the results of the crosstab query within vb ?
    That's what I'm not sure about.

    There is a BeginTrans, then a bunch of lines adding a field to a db (RecStack.AddNew) then there is a CommitTrans... and that's when data is entered into the crosstab query.

    There is some SQL criteria in the query. When does this get activated? I am pretty confused.

    All I really need is a way to move the info from the query to a copy of the query in another db that is blank... with the same structure.

    ??

    Thanks,
    Brian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •