Great to know. But how
To open two databases in one ADO connection?

And what is attacted table?

lupus


Depends.

SQL server 6.5 on same server - yes
SQL server 6.5 on different servers - no
Sql server 7.0 - appears to be yes
Access (any version) without attached tables - no
Access with attached tables - yes

The two tables will need to have a field in common (name does't have to be but the data type and content need to be).

You'll only need one ADO connection to do it, if you can do it.