ADD, RENAME AND DELETE COLUMNS using ADO
 

Hi All,

I would like to ADD, RENAME and DELETE COLUMNS In Excel using ADO.
I am using ADO 2.7, Excel 2002.

I have used the following code for delete column..

conConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=""" & strExcelFileName & """;Extended Properties=""Excel
8.0;HDR=Yes"""
conConnection.Mode = adModeReadWrite
conConnection.Open
strSQL = "ALTER TABLE [" & SheetName & "$] DROP COLUMN [" &
strColumnName & "]"
conConnection.Execute strSQL


Similarly I have used SQL for Adding and renaming columns.

But in all cases I am getting the error -2147467259 Invalid Operation.


Please help me to solve this problem.


Regards,
Paramasivan