Thread: reading *.mdb ( microsoft access )

So how to read it. I just have one table in database, and i wanna read fields from that table,
very simple table.

And the table is very very large, But that doesn't have to do with anything, does it?
( it's about 6MB )

you have to use database operations techniques, such as ODBC or ADO, and you have to know SQL (structured query language). There are lots of books on all these subjects -- not for beginners. If you google around you will find some ODBC c++ classes to make it a little easier.

And SQL language is not standardized. What works on one database may or may not work on others. There is a basic set of SQL commands, but beyond that each database has its own unique set of SQL functions.

Without any information on what your resources are, I would suggest you use the MFC CDatabase/CRecordset classes und Access as an ODBC Datasource.

I'm not gonna use MFC

ODBC is commercial!

Originally Posted by ElastoManiac

ODBC is commercial!

and wtf do you think access is?
ODBC = OPEN database connectivity.
it's actually an open standard USED by commerical products.

Unless you really like writing a tonne of code to read the mdb file by hand (if you are daft enough to attempt this here's the MDB file format), ODBC is your friend. You can use MFC classes, ADO, DAO, ADO.net.

here go learn SQL and try to avoid making statements like that in the future.

"Better to keep silent and be thought a fool, then to open your mouth and remove all doubt"

this is getting too complicated, i'm just gonna extract my table to *.txt and read it with <fstream>
Althought it would be very nice if i'v learned how to handle this stuff.