Data Base(MS Access) connectivity using VC++.

[trin]

How can i connect Database to using C++ program.
Problem:

There is one *.txt file with 3 fields.These 3 fields data is to be inserted into one table with 3 fields in MS Access database using C++ program.

 

[MinAmiChief]

Sorry to evade answering your question but...

Why would you use C++ to import a text file into Access anyway? It is very easy to do this in Access and I can't see any gain from using C++ (Automation?).

Also, Access as a database is very "resource consuming" on the workstation (Assuming its over a network). To me the C++ Access combination is pointless as all of the efficiency gain from C++ is lost when using Access. Try SQL,Betrive or Oracle.

Otherwise I have heard DAO is easy to use.

 

[ame12]

MinAmi is right, IMO. DAO is the easiest way to talk to Access back-ends. Let us know if you need some sample code and we can post it.

===========================================

http://badblue.com

Small footprint P2P web server for Windows,
File-sharing, mobile/wireless apps & more
===========================================

 

[Cagliostro]

You can also use ODBC API.
Is not difficult to learn, but is too much for writing it in the forum.