Using sql to insert data into Access database 
Author Message
 Using sql to insert data into Access database

Hiz,

Eg.

int i;
i = 100;

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



Sat, 29 Jan 2005 11:21:56 GMT  
 Using sql to insert data into Access database

Quote:

>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
-------------------------------------------



Sat, 29 Jan 2005 19:39:22 GMT  
 Using sql to insert data into Access database
Warz

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

regards
roy fine


Quote:
> Hiz,

> Eg.

> int i;
> i = 100;

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



Sat, 29 Jan 2005 21:01:59 GMT  
 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



Mon, 31 Jan 2005 16:37:14 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Insert data into Access database using sql

2. Problem inserting data in SQL database

3. Insert data into Access using ADO

4. Using ADO for SQL Server data access

5. Using ADO for SQL Server data access

6. Using ADO for SQL Server data access

7. Using ADO for SQL Server data access

8. Using C to get at data in Access database

9. Copy Excel data into Access database using ADO for Visual C++

10. Database SQL INSERT

11. Inserting Muliple Records into SQL-SERVER Database

12. Inserting in to a SQL Server Database

 

 
Powered by phpBB® Forum Software