Skip to main content
Solved

Delete Records from Access Database Table


vxn43
Supporter
Forum|alt.badge.img+18

I have a Microsoft Access Database Table. I need to delete all the records in it and just keep the schema. Basically, the output will be an empty table. There are 10,000 records in the table.

 

Delete all records in Table A. Table A will be empty. Just keep the Table A schema.

 

I know I can use the SQLExecutor with a SQL Statement to do this, but how to do this using Transformer(s)?

 

 What is the best way to go about this?

Best answer by takashi

Hi ​@vxn43 ,

I think using SQLExecutor is a way to delete all the records from an existing database table, as you mentiond already. See the help on SQLExecutor to learn how you can use it.

Alternatively, you can also use DatabaseDeleter transformer.

If you have any troubles on using the transformars, please describe the situation specifically.

View original
Did this help you find an answer to your question?

2 replies

takashi
Evangelist
  • Best Answer
  • June 25, 2025

Hi ​@vxn43 ,

I think using SQLExecutor is a way to delete all the records from an existing database table, as you mentiond already. See the help on SQLExecutor to learn how you can use it.

Alternatively, you can also use DatabaseDeleter transformer.

If you have any troubles on using the transformars, please describe the situation specifically.


vxn43
Supporter
Forum|alt.badge.img+18
  • Author
  • Supporter
  • June 25, 2025

Thank you, Takashi. I was not aware of the DatabaseDeleter.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings