how to import data from another database

how do I import data from superbase

Hello,

First some explanation. Base (LO) currently comes HSQLDB embedded v1.8 and is being replaced with Firebird 3.0 embedded. Embedded DB’s are single user only and are zipped into the Base file - thus embedded. Also note, Base can connect to a variety of different DB’s using various connectors (SDBC, ODBC, JDBC) or tables can be constructed from delimited files. There are others but that presents many situations.

So in your case, it is not clear what you are wanting to import to. Most likely you are wanting to move away from ‘superbase’ (know nothing about it). You then need a connection to Base via a connector (you need to find) or create delimited files from your tables. Now if moving to a different database, you need to create a Base connection to the DB you intend to use.

Once you have the two items in place, usually it it just a copy/paste between the two.

In some cases, and nothing to do with LO, you can use third party software to copy data from one database to another. One utility is SQL Workbench/J but it doesn’t mention anything about ‘superbase’. This may be the challenge for you.