Pitney Bowes MapInfo Professional - Manual (Page 366)

Opening SQLite Tables
MapInfo Professional lets you select which tables in a SQLite database to open, and gives you the option
to set display styles, and column and row filters for the tables.
MapInfo Professional works with existing SQLite databases and it lets you create new SQLite databases.
You can open a table in a SQLite database and save your edits, and you can save your new or existing
MapInfo tables to a SQLite Database (*.sqlite).
To open one or more tables in a SQLite database:
1. On the File menu, point to Open.
2. In the Open dialog box, from the Files of type list, select SQLite Database (*.sqlite).
3. From the Look in list, select the folder location of the database that you want to access.
4. From the files list, select the database to open.
To select more than one database file in the Open dialog box, press the Ctrl or Shift key while
selecting files.
5. Click Open. The Select One or More Tables to Open dialog box opens.
6. In the Database Tables list, select a table to open by adding a check mark beside the table name.
You can select one or more tables. Only the tables that have a check mark beside them will open.
7. Optionally, select how you want the data to display on the map by selecting (highlighting) the table
name and clicking Style.
This opens the Change Table Object Style dialog box where you can specify the display style for
geometry (spatial object types), such as symbols, lines, and regions in the table. The custom styles
that you set only apply to the table that you highlighted (whether it has a check mark beside it or not).
To select more than one table, press Ctrl while selecting table names. Your style choices are made
to all of the tables that you select (that are highlighted in the Database Tables list).
8. From the View list, select how you want to open the tables.
Select New Mapper or Current Mapper to open them in a Map window, or Brower to open them in
a Brower window to see the table contents.
9. Click OK.
The table, or tables, from your selection open in MapInfo Professional.
If you choose to open more than one SQLite database (.sqlite file) in the Open dialog box, then each
database opens a Select One or More Tables to Open dialog box. Repeat the previous steps for each
database.
Displaying your Comma Delimited CSV Data
You can work with an y ASCII file in MapInfo Professional, it must be delimited using a space, tab,
comma, or another special character that separates one field from another. Before opening a delimited
ASCII file, you must know the delimiter in use and whether or not to use the file's first line as column
headings. You can check this by opening the file in any text editor, such as NotePad.
If you are working with a CSV file, it must be comma delimited to open it in MapInfo Professional.
If you want to place the point data in your CSV file on to a map, then follow these instructions to open a
CSV file in MapInfo Professional and then proceed to
Putting Latitude/Longitude Coordinates on a
Map .
MapInfo Professional 12.5 366
Displaying your Comma Delimited CSV Data