How to delete a row in Excel using OLEDB?

Question

Hi How can I delete a row in Excel document using OLEDB? Thanks

Javeed M Shaikh · Answer

Hi R P I am not sure if Excel document supports deleting rows using OLEDB you need to find an alternate solution like updating the data with null or recreating a new sheet and dropping the old like 'drop table mytablename'. refer this and goto section Delete Records: http://support.microsoft.com/kb/316934 Please do not forget to mark Accepted Answer.