[dba-SQLServer]Using DTS to get data from SQL to Access

Susan Geller sgeller at cce.umn.edu
Wed Aug 20 09:12:00 CDT 2003


I have written a DTS that populates a table in my Access mdb.  What I
want is for the DTS to first delete all the data that is currently in
the access mdb and then repopulate it with the data from my SQL table.
I can't figure out how to do the delete part from the DTS.  Does anybody
know or where can I go to look for help on this?

--Susan


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568




More information about the dba-SQLServer mailing list