Run MS Query via ODBC on Sybase, append records to SqlServer6.5 1

[tektripper]

I work as a call centre analyst and we use Sybase to store all of our data. Data is gathered stored in Sybase under DateTime field in 15 minute intervals for a period of 2 days and this data is then summarised as daily information. At the end of each week this data rolls into weekly information. Weekly records are stored permanently on Sybase. I would like to keep the 15 minute interval information on a permanent basis by regularly running a query after business hours and appending the records set to tables i build in SQL Server 6.5. My idea is to use MS Query (From Excel 5) to connect to Sybase via ODBC and automatically apppend the records to the SQL tables. I would like to do this using a Macro (or equivalent script). I have little hands on experience with SQL 6.5 but am familiar with Access. Should this be relatively simple to do? Am I on the right track, or is there a better way of doing this. SQL Server sits at my desktop, I have no direct access to Sybase. Thanks very much in advance to any of you legends out there that could offer some advice.

 

[tomschafer]

I don't have any experience with Sybase so I don't know if there is an easier way. But, using what you have suggested, I would..

1. Create an Access db with ODBC linked tables to both Sybase and MSSQL.
2. Create an append query in Access to move the data from Sybase to MSSQL.

Let me know if you need more help.