I'm using Excel 2013 as a datasoure. I am unable to perform DELETE commands on rows when using as a datasource. I am using the following provider for my ADODB: Provider=Microsoft.ACE.OLEDB.12.0
Is there a way to perform a delete or an elegant workaround? Can I perform a SELECT statement and get the specific row of a record? If so I could delete the row via VB.net. Would prefer this to having to search through the table for a matching record.