PDA

View Full Version : Original Making Mapinfo linked table from Access or Excel



telwind
2011-10-20, 01:00 PM
Dear all,

I'd like to create the mapinfo table store geographical data (Site/cells) which directly linked to my excel data store that regular change the lon/lat and other fields. However the link is not created successfully. I tried with both excel and access.

The steps I am following are:

1. Create Excel File (or access)

2. Create a named area around the data containing the Lat/Lon and
any other information wanted visible in the MI table.
3. Create a new DSN name based on the excel document
I am making a File data source as I want the file to sit on the my PC.

I have tried using both the Drive Do Microsoft Excel and the Microsoft
Excel Driver

4. Open DBMS table with the selected feilds using the linked table
option

The table opens, however displays "The table you have downloaded
cannot be edited, see the Map Info User Guide for more information".

5. The issue is that when i go to make the table mappable after
selecting XYCoordinats in Index box and the lat long columns for the
X and Y cooordinate I keep getting following error.

ODBC Error: ODBC RC= -1, ODBC SQLState = S0002, DBMS RC =-1305,DBMS
Msg=[Microsoft] [ODBC Excel Driver] The microsoft Jet database engine
could not find the object ' MAPINFO_MAPCATALOG' Make sure the object
exists and that you spell its name and the path name correctly
Then the error: "The table you have chosen cannot be mapped, The be mappable, a table must contain a spatial column, or at least two numeric columns".

How can I fix this problem?

pl_ev_7
2011-10-20, 03:06 PM
@telwind

Create the dbms catalog! Go Tools and load DBMS Catalog. The toold is pretty much self explanatory. Unless you create this catalog, you'll not be able to pull the coordinates from the DB.

If you need any more details just pm me

telwind
2011-10-21, 10:36 AM
@telwind

Create the dbms catalog! Go Tools and load DBMS Catalog. The toold is pretty much self explanatory. Unless you create this catalog, you'll not be able to pull the coordinates from the DB.

If you need any more details just pm me

I did the steps from MI following steps from this but not successful: Knowledge Base - Document - Opening an Access table via ODBC in MapInfo Professional v.7.0. (http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase__by__product/B2719BA0C1DCD0AD85256C54006BB54A)

Please check your PM.