I'm developing a UWP application and want to read a MDB file to convert this database to a SQLite database.
I read that i could use OleDbConnection
to open MS Access database following this topic : connect and read .MDB item with C#
But OleDbConnection is not available in UWP project. It seems not available in System.data
Do you know solution to read MDB file in a UWP application programatically?
EDIT :
Microsoft team answered me this information :
Currently, there are no in-box API, or tools compliant third UWP out-of-the-box that allows you to do that.
There is nothing in the roadmap for the moment regarding this point!
I propose you two tracks to explore:
- Convert your .mdb file into sqlite "Ready to use".
- Develop Web API that exposes the data of your mdb.
There's nothing in-box to do this. I'm not aware of any 3rd party libraries that understand .MDBs and supports UWP apps.
I'd convert the .MDB to SQLite from a non-UWP app and then have the UWP app deal only with SQLite.
It looks like there are many existing tools to do the conversion