Hi

I have successfuly exported a table to an existing Access
database table but need to overwrite the existing table in
Access rather than it appending the data each time as it
is doing now. I have looked and looked for an overwrite
option but cannot find... Am using SQL2000.

thanks in advance
Alison

Why not then use an ExecuteSQL task that points to the Access DB and then
issue DROP TABLE <tablename>. You can then issue a CREATE TABLE statement.

--
--

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


"Alison Towerton" <anonymous (AT) discussions (DOT) microsoft.com> wrote

If all yoir doing is copying the table in the package you can use the
Export Wizard to export to Access. This will give you the option to drop
the table in the Transformation dialog box.

Rand

This posting is provided "as is" with no warranties and confers no rights.