Transfer table from SQL to Access

[BukHix]

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?

[MikeStammer]

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

[BukHix]

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

[MikeStammer]

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

[BukHix]

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

[BukHix]

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.