LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Borg_species5618

Hello All,

Not too familiar with outputting data to an MS Access database via an ODBC link, but I have tried using the node "DB Clean Loader"
This works but it appends, when I would rather delete the existing data in the table first.

Currently I am using "DB Execute" node to first delete the data then I use the "DB Clean Loader" to append to the table.

Is there a better way ? ie use just one node (DB Execute) to delete existing data in an MS access table and then append data from a filter node to the MS Access table.

I am basically not familiar with appending data to an existing table using the DB Execute node

The table name is ABC and the field names are Customer_Name, Region and Product

Thankyou

Frank

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

In the DB Clean Loader node there is a parameter "CleanResults" that is under the "Optional" tab. Make sure this is set to "ALL" and it should remove any data in the table before loading.

The DB Clean Loader node uses an SQL Truncate to remove the data. If MS Access does not allow a Truncate then using the DB Execute to remove the data is the correct solutions.

Thanks,
Larry

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

You will also need to Compact and Repair the DB otherwise MSACCESS will still utilize all the space used by the previous data.
Access has limits on size so I'd recommend you'd investigate how to execute that too