Good morning everyone. Given the many difficulties I have in exporting my application with access database on linux, I was wondering if perhaps it is easier to convert the database to sqlite. What do you think? And if so, how do I convert it to sqlite? I have the access database with many tables and data points and I cannot lose anything.
You loop over the tables and make new ones, then you loop over the fields and make new ones and then you loop over the data and make new data for every field and every table. Usually not fun work.
On Windows you can use the ODBC plugin classes in Xojo or MBS SQL Plugin to connect to access database.
Then copy data over.
export the table as SQL, make any adjustments needed, then run the sql against your chosen database.
Edit: You can also export the tables as CSV’s and import them into your chosen database that way.
MDB / ACCDB Viewer
Not free ($19).
1 Like
Not sure how good this is but this runs on Linux
Copy the mdb file to Linux, use the above to extract table defs & data
Ok, I’m not a professional programmer and I have no idea how to do it. Is there a practical example to download and study?
Well, the MBS Xojo Plugins download comes with examples for SQL including one for Microsoft Access.
what is the database size ?
I have the macos mdbviewer, send me a PM and I can do the export for you if you only need it once ?
It’ 25 MB
Maybe it is too late. Otherwise, you may consider DBeaver, they have a free version and plugins for many db types, including MsAccess ( at least on Win) and SQLite.
Hope this helps.
Thanks, it’s never too late to learn something new 
I’ve already solved and converted my tables to sqlite anyway. Now in my free time, I’m modifying the program for sqlite. Thanks.