I am trying to do an insert statement into SQL Server from an Access mdb. I notice when I try to do a heterogeneous query in TDA that it defaults to connecting to Access as its primary connection, and uses a connection string to connect to SQL Server. I need it to work the other way around.
Is this possible in TDA?