Has anyone tried running a DTS package from VBA?
I am looking to import from a standalone MS Access database into my main SQL Server 2005 database via an Access 2005 front end. Currently I link to the standalone tables and run a straightforward append query but as this tends to be approx 24,000 rows at a time the process is rather slow. It is MUCH faster via the Import Data Wizard in SQL Server Management Studio - I have saved the DTS file locally and would like to be able to call this from VBA.
Thanks very much