Archive data in MS-Access from VC++

[dharnidhar]

Hello,
I would like to export and import data to and from formatted files from an MS-Access database. As far as i know there are two ways of doing it in Access viz. using Macros and VBA. But how can I do it from a client written in VC++. I would like to export data selectively based on a where clause.
Help Please !!

ThanX and Rgds

[Fraser]

If you are using MFC, then you can manipulate an Access database through DAO classes provided for you.

Check the documentation for classes:

CDaoDatabase
CDaoRecordset
CDaoQuerydef
etc.

Hope this helps.

Please send mail to me..
And I will send a sample program.
This program used dao( in order to import and export data from MS-ACCESS ).
e-mail Addess is belowed :
[email protected]
I will wait for yours.

Why not use ADO? Ado works fine when connecting to0 MS-Access database. Furthermore this is the technology Microsoft wants us to use because it belongs to the OLE-DB group...