insert Ado
Publicado por gustavo (15 intervenciones) el 24/09/2003 17:57:25
si quiero realizar un update anda bien pero cae en el insert alguien me puede dar una mano
gracias
Public cn_Connection As ADODB.Connection
Set cn_Connection = New ADODB.Connection
With cn_Connection
.ConnectionTimeout = 0
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_DSource & "\" & str_DBName & ";Jet OLEDB:Database Password=" & "XXX" & ";Persist Security Info=False"
.CursorLocation = adUseClient
.Open
End With
cn_Connection.Execute "insert into tabla '1'"
me da el error Syntax error in INSERT INTO statement. (-2147217900)
gracias
Public cn_Connection As ADODB.Connection
Set cn_Connection = New ADODB.Connection
With cn_Connection
.ConnectionTimeout = 0
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_DSource & "\" & str_DBName & ";Jet OLEDB:Database Password=" & "XXX" & ";Persist Security Info=False"
.CursorLocation = adUseClient
.Open
End With
cn_Connection.Execute "insert into tabla '1'"
me da el error Syntax error in INSERT INTO statement. (-2147217900)
Valora esta pregunta


0