Transfer table from SQL to Access

Does anybody have a code sample or know of a tutorial for transferring tables from SQL Server 2K to Access?

I am writing a VB application with a form that needs to do this once a week so I am looking for a way to automate the process.

I found this article and I think it is what I need but the code is missing.

http://www.zdnet.com.au/builder/arch...0274922,00.htm The transfer of data from one format to another is a common programming chore. Programmers can simplify the process by using SQL Server via Data Transformation Services (DTS), which is tightly integrated in the Microsoft product line.

Any ideas?

There is no code if you use DTS. it is built into SQL Server. Works great.

OK I can probably figure out the SQL part but how do I initiate DTS to run from my VB.Net app?

MSDN should have that info for you. You can always schedule it via SQL job agent as well if its a weekly thing

Scheduling it won't work for this particular application because the transfer has to be user initiated per certain criteria.

I have Googled for some information about doing this but all I could find worth anything was the link I posted above. I'll check out MSDN for some info.

Thanks

Anybody?

I have the DTS working correctly but I can not figure out how to run it from code. This article "Executing a DTS Package in a Stored Procedure" lists three solutions but there are no samples included.