I need to trigger a CSV file import into a SQL Server
database from Access, using VBA code.

Is there a way to trigger a DTS local package from an
Access VBA module ?

Many thanks for any help,

Jonathan.

A few ways of doing it but you could easily use the Object library

Execution
(http://www.sqldts.com/Default.aspx?104)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"JonathanK" <Jonathan.Kahn (AT) AIG (DOT) com.DROPTHIS.FOR.NOSPAM> wrote