I am trying to do an heterogenous query (insert in a different server
than the server holding data to be inserted) between 2 Sybase servers
(using DAO connectins) based the Jet help file:

INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression

Microsoft says you can do this with ODBC datasources and MS SQL Server.

I am wondering if this is possible with Sybase servers and if anybody
has some code samples to illustrate this.

Appreciate your help,
Catalin