VB.net MS ACCESS database update syntax (inserting data) (easy)
Posted on 2003-03-27
Hi. My Database Table (MS ACCESS) looks like this.
Symbol Date Price
INTC 06/07/1982 15.00
INTC 06/08/1982 15.01
INTC 06/09/1982 15.05
MU 06/05/1985 1.00
MU 06/06/1985 1.01
MU 06/07/1985 1.05
As you can see there are 3 columns.
I have about 600 megs of data like this.
I want to add records into this table...
For Example, I want to add:
INTC 06/10/1982 15.06
I have been using DB.Execute(cmdstring, , ADODB.CommandTypeEnum.adCmdText)) where DB is my database connection.
I am only familiar with command strings which extract data from my database into a recordset, such as:
"SELECT Symbol,DDate, Price FROM Full WHERE Symbol = 'INTC' And DDate >= #06/07/1982# And DDate < #06/07/1983#"
I assume there is a command string which will update the database...
Unfortunately I haven't found a good source for these SQL statements...
Thanks for your help!