Importing LebreOffice .ODT Base data files

[Rasputinxxxxxxx]

Can LebreOffice ODT files be imported to Access?

[June7]

From what I read https://www.howtogeek.com/765461/wha...-you-open-one/, this is a document file similar to Word docx file. docx is not a data file and not importable and I would expect same case for odt.

[Rasputinxxxxxxx]

From what I read https://www.howtogeek.com/765461/wha...-you-open-one/, this is a document file similar to Word docx file. docx is not a data file and not importable and I would expect same case for odt.

The file I have and would like to import to Access is a LibreOffice database file.

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

[June7]

Okay, from LibreOffice site:

Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.

And another source:

Can Libre Office Open MDB?
You actually do not open an .mdb file with LibreOffice. LibreOffice contains Base. This is a front end (not a database) which can connect to various databases.

If you can't connect via import/export wizard or maybe ODBC driver, than no, cannot import to Access.

[Gicu]

Looks like the only way to do it is to export the individual tables from the .ODB file as CSV (text) and import them into a new Access file.
https://www.file-extensions.org/convert-odb-to-accdb
Cheers,