>Is there a way to execute a DTS package on SQL server from within Visual Basic or within Access' VBA code?
You should have this sample on your PC if you installed SQL: C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\dts\unzip_dts\DTSTasks\DTSExecutePackage
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com