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

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