"Mark - HIS" <MarkHIS@discussions.microsoft.com> wrote in message
news:98C63863-8BB9-4415-B6D8-D23F32DBD5DB@microsoft.com...
>I have a query to pull data from my MSSQL database, howver I need to use
>the
> INSERT INTO statement to insert the results into a Sybase SQL Database on
> a
> different Server to the one the MSSQL database is on.
> I have set up the Sybase SQL Database as a DSN in the ODBC Administrator,
> but how do I get the query send the results to the Sybase SQL Database.
> The
> query will ultimately end up being in a 'Job' on the MSSQL Database to run
> on
> a regular schedule.
>