how to read/write to Microsoft Access MDB file?

[serendipity1276]

Hi,

I want to write a test program in C, that will allow me to do the following:

Read and write to an Access 2003 mdb file, named c:\test\db.mdb

I simply want to write these 4 values into a table named "data" inside the file c:\test\db.mdb

123A 10.50 5.75 20.2

Afterwards, I want to read the whole table named "data" from that c:\test\db.mdb file (it always will only have 4 fields), and print its contents to the screen , that may look something like this:

ID X Y Length
100 6.60 2.15 10.5
105b 15.75 5.00 18.6
123A 10.50 5.75 20.2


If you know how to do this, or have a similar C program that will solve this problem, please post. Thank you.

[AndrewHunter]

This isn't an easy task, and often is not worth the effort. If you want to automate Access just look into using VBA in making your solution. However, if you want to do this in C your best bet would be to look for 3rd party libraries that provide the functionality you want to interface with Access.

All of Microsoft Office exposes its methods through COM interfaces. If you actually want to do this without any 3rd party support look at MSDN for articles which explain the COM API for Access.

[stahta01]

This might help you.

Microsoft Jet Database Engine - Wikipedia, the free encyclopedia

Tim S.