How can I add a new column in an excel file correctly?

[ATC]

I am able to create a table with some columns in an Excel file & I can add or read data from those columns. But when I try to add a new column (NewInfo) with the following codes ... I had an error "Invalid operation" after line cmd.CommandText = "ALTER TABLE ..." Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConn1) conn1.Open() Dim cmd As New System.Data.OleDb.OleDbCommand() cmd.Connection = conn1 cmd.CommandText = "ALTER TABLE EmployeeData ADD NewInfo VARCHAR(20) NULL" cmd.ExecuteNonQuery() conn1.Close() Might someone show me what is wrong? Thank in-advance :confused:

[Dave Kreskowiak]

ATC wrote:

cmd.CommandText = "ALTER TABLE EmployeeData ADD NewInfo VARCHAR(20) NULL" cmd.ExecuteNonQuery() conn1.Close() Might someone show me what is wrong?

The Excel driver doesn't support the "ALTER TABLE" SQL statement. You have to add the columns using the Excel object model.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[ATC]

Thank for the explaination, now I know why it has not work! Would you kindly provide some links to use the Excel object model. I appreciate a lot! Many thanks

[Dave Kreskowiak]

MSDN docs on the Excel object model[^], complete with examples.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007