Am trying to select data from one database and then inserting it into another database. Tryed to use a select statement in conjuction with an insert into statement. The problem arises that when you wish to insert into a database, you specify a connection and execute that connection. To my knowledge, you can only open one connectionstring to every connection.
Anyone

It Ends Here

__________________
It Ends Here

Yes, just one conn string per connection. You don't say what rdbms you're using, but most have syntax that will allow inserts into another database via SQL. For example if it's Access you can add the IN clause to specify the database; if SQL Server you can use full 4 part name to specify the other server/db with a linked server setup.

Yes indeed. Thankyou kind pgtips.

It Ends Here