Could someone tell me how to use the insert command to add a record into an access database. just need the basics, i can add onto it from there
Printable View
Could someone tell me how to use the insert command to add a record into an access database. just need the basics, i can add onto it from there
Unless you're SQL is good enough to write the insert commnd yourself, I would recommend using the command builder. The format is something like
VB Code:
where da is your data adaptor. I'm doing this from memory so you may want ot check your help files.