I am connecting to my Access DB via ADODB connection (from Excel), I can delete all, but I cannot delete a subselection of data.
This works:
sSql = "DELETE ManualSplits.* from ManualSplits"
cn.Execute sSql
This does not work
sSql = "DELETE ManualSplits.* from ManualSplits WHERE...
Hi I'm Reenen.
I need help with a query, but this is just my introduction thread. I am 34, from South Africa, and I work for a retail chain. I am struggling with my ADODB connection between my excel and access DB. But will be posting that here soon.