Cannot Delete a MSAccess table from UiPath

[bob.nims]

I have a simple access query that makes a new table. When I am in Access it challenges me to say yes to overwrite the table.

When I try to run the query from uipath it errors and tell me the table already exists.

I would like to simply delete the old table before running the make table query.

Is there some kind of code I can use to delete the table first?

[bob.nims]

This is what I am doing so far…

[Nithinkrishna]

Hey @bob.nims

I guess you can use Drop Table query

Thanks
#nK

[bob.nims]

That worked! Thank you. I read something on that and it seemed it was only for SQL server and would not work with access. Apparently, it does.

THANK YOU!

[Nithinkrishna]

Cool buddy