Click here to Skip to main content
14,693,130 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
May i know using OpenXML, can we read microsoft access database (MDB)? If so, any reference is available? All the examples talks about processing Xls, PPT or word and did not find any on MDB.

What I have tried:

Googled.

All the examples talks about processing Xls, PPT or word and did not find any on MDB.
Posted
Updated 22-May-20 0:51am
Comments
Maciej Los 22-May-20 4:54am
   
What for?

No, you cannot use OpenXML to open a .mdb file.
   
Comments
Maciej Los 22-May-20 5:55am
   
5ed!
phil.o 22-May-20 6:15am
   
Thanks :)
If you do not have Microsoft Access you can read the file's contents through the OLEDB interface using the Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^] . This article: Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^], although written with Excel in mind will show how to get the schema tables and from there how to read the individual records of the database using normal SQL commands.
   
v2
Comments
Maciej Los 22-May-20 5:55am
   
5ed!
Richard MacCutchan 22-May-20 6:05am
   
:thumbsup:
Sampath579 22-May-20 10:10am
   
Thanks. Basically i dont want to depend on office software which is heavy prerequisite. So which one would give a better performance? Office components or OLDB and my application is 64bit.
Richard MacCutchan 22-May-20 11:25am
   
OLEDB works fine for reading access databases. Performance will, as always, depend on what you are doing.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900