Hiz,

Eg.

int i;
i = 100;

How to use sql to insert data using i = 100 into Access
database?

Use a recordset or a CDatabase. If you're just using Access, take a
look at ADO or DAO.

Paul.
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------
NB Spam trap in e-mail address
-------------------------------------------

Warz

see response to previous - it has inserts into access (jet) database using
ado.

regards
roy fine

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