Delete records from db table

[rajamahajan85]

What is the easiest simpler way to run DELETE*FROM TEST1 query? Its quick to do odbc connection using input tool and put the SELECT*FROM TEST1 and get the result, however using same method when i write DELETE query, it errors out. I have both read and write access for the db table. I can use same DELETE query in the Sql server and b able to delete entire data table. Could someone provide suggestion?

[redruby]

Hello, 

I have a similar issue, however, I wish to delete only current year data in order to reload since it changes every day. I have loaded my initial table with 2019, 2020, and 2021. I wish to do the following:

Delete 2021 records first

Insert new 2021 records (append)

Table currently has 16 million records and don't want to wipe then entire table and reload each time. Any help is truly appreciated. Not sure if I need to start a new post or receive a reply within this thread. 

[ImadZidan]

Hello @redruby ,

Just to be sure. Your source is excel and destination is a database or your source and destination is a database.

Many thanks

Imad

[redruby]

Yes, source and destination is a database.