Insert a record using SQL

[irocz]

Hi,
I am trying to use SQL to insert records in a table without the use of a Data control, my connection string works, I've been successfull using Select * from table, but I can't use a string to insert using the execute method, Is there another way, or am I missing something?
Here is what I have :
Dim db as database
Dim rs as recordset
set db = opendatabase("c:\folder",false,false,"dbase iii;&quot
set rs = openrecordset("select * from table order by date&quot
db.execute "Insert into table(field1,field2) values(variable1,variable2);"
Thanks for your help

 

[DJTN]

I would build it into an XML document then Use a XSLT doc to create the table.

 

[irocz]

I think you either responded to the wrong thread or, if not, I do not understand your response, since I do not know xml. I already built the table, just want to add to it.
thanks

 

[CajunCenturion]

You might try the following:

Assuming that variable1 and variable2 are stringvariables:

db.execute "Insert into table(field1,field2) values('" & variable1 & "', '"& variable2 & "');"
Good Luck
------------
Select * from Users where Clue > 0
0 rows returned

 

[irocz]

Thanks..that worked..