SQL question.

I need to know how I can load a database from VB. I'm reading info into variables, created the database with VB and SQL commands, but don't know how to wright that info into a particular field in the database.

Can anyone help?

[Clunietp]

UPDATE MyTable set MyField = 'MyNewValue' where KeyField = MyRecordID

Ok, looks good, but this is the first time I do this. Can 'MyNewValue' be a variable?

And do you know of a good Webpage that details these SQL commands with examples?

AmigaZoid

[Clunietp]

Yes you can use a variable, and yes, I do know of a good web page that is a great reference:
http://w3.one.net/~jhoffman/sqltut.htm

Great, Thanks.

One last question....

Can any SQL command be used in VB?