
Using sql to insert data into Access database
1. You can use the AddNew method of ADO to insert a record into a table.
For more details, please refer to:
Title: AddNew Method Example (VC++)
URL: http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthaddnewxvc.asp
2. You can use the Execute method when run from both a Command object and a
Connection object. Please refer to:
Title: Execute, Requery, and Clear Methods Example (VC++)
URL: http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthexecutexvc.asp