Kitz Forum
Computer Software => Windows => Topic started by: Peter on September 26, 2018, 11:00:52 AM
-
I have a data base on a memory stick I made with Microsoft office which I no longer have, I want to open it in Libre office, can anyone suggest how I can do so please.
My OS is Win 10
Regards
-
What format is the database in. Is it an Access database. If so, is it an .mdb or an .accdb file.
-
There might be services on the web that can convert these file types into some file format that your software does support. Would have to find out what kinds of exact file formats your software can ingest without belly ache or upset.
-
Hi they are is .mdb files.
Pete
-
Would need to know what your software can digest then.
-
Is this any use ? https://wiki.documentfoundation.org/Faq/Base/How_to_connect_to_a_Microsoft_Access_database
-
The Access .mdb file is proprietary to Microsoft so only Access or other Microsoft Office products such as Excel is able to open them. The database file will include tables and possibly indexes, forms and views.
If you just want to access the data in table form then this link may be the answer https://ask.libreoffice.org/en/question/152917/migrating-from-ms-access/
-
Apparently Libre Office can connect to MDB files
https://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
https://ask.libreoffice.org/en/question/145877/mdb-files-not-loading-to-base/
-
I thought the ODBC drivers for MS Access were included in all windows versions since at least XP and probably earlier. You should be able to get any application that has ODBC capability to retrieve the data.
(That won't help if you have form design and code you want to retrieve)
-
What jelv said.