I Have Problem While Droping Column From Excel Table Using Oledb Connection By Using Microsoft Jet Provider
I Use Following Code
Alter Tablename Drop Columnname
Code Runs Successfully But It Removes Text From The Sheet And Adds Last Field's Text To The Droped Column
So What Would Be The Best Way To Do This By Using Ado.net