Move Query Data from DB to DB

[briglass]

Hello all!

I have two databases and both are exact copies. They both have a crosstab query. One of the queries has data in it.

Is there a way, from within Visual Basic 6.0, to quickly move the data?

Or, is there a way, from within Visual Basic 6.0, to simply move the entire query, data and all, from one DB to the other?

Thanks,
Brian