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 SQL, or ADO?

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!