Saving Your Data to a SQLite Database - MapInfo_Pro - 2023

You can save your MapInfo tables to a new or existing SQLite Database (*.sqlite).

Saving your Table to a New SQLite Database

Before you begin, you must have a MapInfo table open in either a Map or Browser window.

To save your data to a new SQLite database:

1. On the HOME tab, in the File group, click Save Table or Save Copy As.
2. If the Save Copy As dialog box opens, select the table to save from the list of open tables and click Save As.
3. In the Save Copy of Table As dialog box, select SQLite Database (*.tab) from the Save as type list. Make the following optional selections for the SQLite table that you will create for your data:
   • From the Save in list, select the location to save the new SQLite table to.
   • In the File name box, type a name for the new SQLite table, or keep the default name.

     Click Save.

4. In Select SQLite Database File dialog box, make the following optional selections for the SQLite database that you will create:
   • From the Save in list, select the location to save the new SQLite database to. You can specify a different location for the SQLite database than what was specified for the SQLite table.
   • In the File name box, type a name for the new SQLite database, or keep the default name.
   • Select the Create MapCatalog Table check box if you want this SQLite database to have a Map Catalog. To decide if you want a Map Catalog, see Using a MapInfo Map Catalog with a SQLite Database.

     Click Save.

MapInfo Pro saves the SQLite table and SQLite database and opens a connection to the new database.

To work with this new SQLite table, on the HOME tab, in the File group, on the Open list, click Table. In the Open dialog box, select from the File of type drop-down list. The new SQLite database is in this list of available file types and database connections. The SQLite database name is prefaced with FDO, so the database MyDatabase.sqlite is FDO: MyDatabase.sqlite in the list. In the Select one or More tables to Open dialog box, check the table name in the list and then click OK. For details, see Opening SQLite Tables.

If you chose not to create a Map Catalog for your table, you can do so at a later time as described under Manually Creating a MapInfo_MapCatalog.

Adding your Table to an Existing SQLite Database

Before you begin, you must have a MapInfo table open in either a Map or Browser window.

To add tables to an existing SQLite database:

1. On the HOME tab, in the File group, click Save copy As.
2. If the Save Copy As dialog box opens, select the table to save from the list of open tables and click Save As.
3. In the Save Copy of Table As dialog box, select a SQLite database connection from the Save as type list. If you do not see the SQLite database connection in this list:
   1. On the HOME tab, in the File group, in the Open list, click Database Table .
   2. In the Open DBMS Connection dialog, select FDO (SQLite) from the Connection Type drop-down list, and then click New.
   3. In the Select SQLite Database File dialog box, select the location of the SQLite database from the Look in list. Select the SQLite database name and then click Open.

      The Save Copy of Table As dialog box refreshes the Save as type list with the SQLite database name.

4. Make the following optional selections for the SQLite table that you will create for your data:
   • From the Save in list, select the location to save the new SQLite table to. It does not have to be the same location as the SQLite database that you are saving to.
   • In the File name box, type a name for the new SQLite table, or keep the default name.

     Click Save.

5. In the Save As dialog box, make the following optional selections for the MapInfo TAB file that will save for this SQLite table. The MapInfo TAB file will store metadata for the table, such as the table type and path to the SQLite database that the table is stored in.
   • From the Save in list, select the location to save the TAB file to. We recommend keeping the default location, so that it is easy to find your tables.
   • In the File name box, type a name for the new SQLite table. We recommend keeping the default name, so that you will know which TAB file belongs to which SQLite table.

     Click Save.

MapInfo Pro saves the new SQLite table to the SQLite database.

To work with this SQLite table, on the HOME tab, in the File group, click Open, and Database Table. From the File of type drop-down list, select the SQLite database name (such as FDO: MyDatabase.sqlite). In the Select one or More tables to Open dialog box, check the table name in the list and then click OK. For details, see Opening SQLite Tables.