Question

Hello
I m trying to add new column to the Excel worksheet by command

ALTER TABLE [MyTable] ADD COLUMN Field_dest nvarchar

But on execution of the command got exception "Invalid operation" I tried table name with and without $ at the end , but got the same result
My questions are
1) Is there some wrong in the command above?
2) Is command ALTER table supported for excel table ?
3) Is the alternative way to add column into excel worksheet - preferable via OLEDB ?

预收

Answer 1

不过,法国家庭援助协会可以创建表格或选择Into,使你能够制作新的表格。我不能从公开发言开始。

Dim cn As Object
Dim scn As String
Dim sSQL As String

strFile = "C:Docs	est.xls"

scn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
strFile & ";Extended Properties=""Excel 8.0;HDR=Yes;"""

Set cn = CreateObject("ADODB.Connection")

cn.Open scn

  Note that there is no $ on the sheet to be created
sSQL = "SELECT *,   As NewField INTO [Sheet17] FROM [Sheet4$]"

  Jet data types
sSQL = "CREATE TABLE [Sheet8] (AText text, ANother text)"

cn.Execute sSQL

如果你拿着公开档案的话,你就会犯错,说不存在。

Answer 2

You can use Create Table instead of Alter Table. Just use your existing table name, then your columns adds to existing sheet

CREATE TABLE [ExistingSheet$] (ID char(255), oldField1 char(255), newField2 char(255))

工作!

友情链接