petermeachem
Programmer
I've a problem with a VB6 ADO programme. I have two connections, one to databaseA and one to databaseB. DatabaseB happens to be Access, DatabaseA can be anything at all. I am building a query on tables in DatabaseA by selecting tables and fields, so I end up with a string representing a select query on DatabaseA. What I want to do is to import the data into DatabaseB. I've ended up doing a creating a table in DatabaseB with the right field names and made them all big text fields. I am looping on the select query and doing an addnew into DatabaseB.
This seems a bit crummy.
What I would like to do is
SELECT Fielda,Fieldb FROM TableA in DatabaseA INTO DatabaseB.
How can I do that?
I'm going to cross post this in a sql forum.
Peter Meachem
peter@accuflight.com
This seems a bit crummy.
What I would like to do is
SELECT Fielda,Fieldb FROM TableA in DatabaseA INTO DatabaseB.
How can I do that?
I'm going to cross post this in a sql forum.
Peter Meachem
peter@accuflight.com