delete row in excel vba with sql Adodb

I created a data entry form using sql adodb vba exce with excel database.

i can update,insert,search,and query anything  except delete.

But I need to use delete button can u help me.

delete * from [Sheet1$] where ID=‘raju’

is there anyway to delete this in vba using sql

Participant Asked on May 23, 2018 in VBA: User Forms.
Add Comment
1 Answer(s)

There are a few activities that you can’t perform on Microsoft Excel worksheets or workbooks through the Microsoft Excel installable ISAM, Delete is one of them. Providing the cells don’t have any formulas you can clear them or modify them. Rather than deleting have a go at overwriting. In the event that this solution does not work for you. You may need to resort utilizing VBA from inside Excel. Here you can check my essay writing service to having a wonderful support for your composing works.

Top Contributor Answered on June 18, 2018.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.