Displaying your sqlite data – Pitney Bowes MapInfo Professional User Manual
Page 365
3. Choose an Access database to open. If security is turned on, you will be prompted to give user and
password information to open the database.
4. The Open Access Table dialog box displays the tables for the opened database.
5. Choose an Access table or tables to open. The table or tables are opened in MapInfo Professional.
(Please note that for a table name with a space such as Order Details can be saved in MapInfo
Professional but subsequently will not be visible to MapInfo Professional.)
After you open an Access table in MapInfo Professional for the first time, MapInfo Professional creates
a definition for the table and gives it a .TAB extension. This enables you to it treat it like any other MapInfo
Professional table. For example, to open this file you would now open it like any other MapInfo Professional
table.
Even though the table has the .TAB extension in MapInfo Professional, your data is still in your
original Access database table and is not a duplicate.
Note:
The Help System contains these related topics:
• Microsoft Access Table Specifications
• Creating an Access Table in MapInfo Professional
• Saving a MapInfo Professional Table as an Access Table
• Saving an Access Table as Another Access Table
• Limitations of Working Directly with Access Tables
Displaying your SQLite Data
MapInfo Professional supports SQLite databases through OSGeo FDO Data Access Technology, so
that you can work with spatial data stored in SQLite database files. This means that:
• you can display your existing SQLite data on a map in MapInfo Professional;
• you can save your MapInfo tables to your existing SQLite database to take advantage of the capabilities
provided by a transactional SQL database engine;
• you can create a new SQLite database from MapInfo Professional;
• you can share spatial data with other applications, such as Autodesk products: AutoCAD Map 3D,
Civil 3D, and Autodesk Infrastructure Modeler.
To start working with your data stored in a SQLite database, see
FDO (Feature Data Objects) is an interface for storing, retrieving, updating, and analyzing spatial data.
MapInfo Professional installs an FDO Provider for SQLite (spatial), so that you can work with SQLite
database files. The OSGeo FDO Data Access Technology stores geometry data to a SQLite database
as FGF (Feature Geometry Format) objects. For more information about FDO, see http://fdo.osgeo.org.
MapInfo Professional works with data created in Autodesk products, such as AutoCAD Map 3D, Civil 3D,
and Infrastructure Modeler, that has been stored in SQLite database format. You can view this data in
MapInfo Professional, save changes made to the data, and then continue to work on the data in the
Autodesk products.
For background information:
• about SQLite, see
• about FDO, see
For more information, see the following topics in the MapInfo Professional Help System:
• Mapping FGF Objects in a SQLite Database to MapInfo Objects
• Using a MapInfo Map Catalog with a SQLite Database
• Working with SQLite Tables
• Sharing Data with other Applications
365
MapInfo Professional User Guide
Chapter 14: Putting Your Data on the Map