How can I import/export from a SQL database some data ? 3

[youssef]

Hi,

How can I import/export from a SQL database some data ?

I don't know if I must to insert a activex or anything for import/export data in my program.

If anyone have a solution or say where I can find information .

Thanks a lot

 

[Cagliostro]

If you want to use ActiveX, use ADO. Alsou you can use DAO, ODBC and many APIs. John Fill

ivfmd@mail.md

 

[IonelBurtan]

You can use ODBC and the MFC classes:
-CDatabase
-CRecordset
This classes have all the functions you need.
There are also some API calls but I don't recomend them because they are a lot more complicated for the same result.

Hope this helps,s-)
Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb

 

[PalaniappaBabu]

Use ADO, which has been recommended by Microsoft to deal with databases from Front-Ends.

You can use
_ConnectionPtr,
_RecordsetPtr.


Please check this tutorial which will be very useful for you getting an Idea about ADO.

http://codeguru.earthweb.com/mfc_database/Ado_Aok.shtml

 

[Cagliostro]

Some databases has theyrs own APIs. They are much faster than ODBC. Usualy ODBC is the fastest way to access databases. DAO can be sometimes faster than ODBC. If you're using Oracle or MySQL look up for theyrs own APIs. John Fill

ivfmd@mail.md