I know how to open a database connection via ADO to an Access DB but how would I do the following:

I want to open a db connection and issue an SQL statement which INSERTS data from a table in that db to another table in another db... Does that make sense? Would I need to create 2 db connections? If so, how would the code look? In know how the INSERT INTO SQL statement would look if the tables were in the same db but I'm trying to go from one db to another and not sure how it would be accomplished..

This needs to be done strictly in VB without using Access objects..

Thanks for any help you can provide...

Dan

[VB6]