I still use DTS to copy the data from Sage into copies of the Sage tables that I created.

It does import all the records though but I am using SQL 2000 rather than 2005 as my system has been running for a good few years.

If it's any help Microsoft Access has trouble linking to Sage data if you specify one of the Sage columns as a primary key and this can cause it not to pull any records out. I've never found found if this was the fault of Access or the Sage ODBC drivers or just behaviour by design.