Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

File extensions .mdb (older version) and .accdb (newer version) are used in MS Access. Files with these extensions are not directly translatable to LO Base.

File extensions .mdb (older version) and .accdb (newer version) are used in MS Access. Files with these extensions are not directly translatable to LO Base.

Thank You peterwt & oweng for your direction. This led me to investigate further. Not using Windows any more ( 20+ yrs - couldn't take it) using Excel was out and the wiki referred to connection in Windows.

I did discover Apache Drill but after about 45 minutes I was still confused. What I also found was ucanaccess . Had a bit of trouble at first until using this step-by-step at askubuntu . Found an old .mdb file, walked through the steps and all the tables were there.

As expected, it was only the table data and no forms or code.