Thanks Thanks:  0
Showing results 1 to 3 of 3

Thread: Making Mapinfo linked table from Access or Excel

  1. #1
    BannedUser Reputation: 970
    Join Date
    2009-10-22
    Location
    The Air
    Posts
    501


    Default Making Mapinfo linked table from Access or Excel

    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?

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #2
    Member Reputation: 68
    Join Date
    2008-01-02
    Posts
    68


    Default Re: Making Mapinfo linked table from Access or Excel

    @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

  4. #3
    BannedUser Reputation: 970
    Join Date
    2009-10-22
    Location
    The Air
    Posts
    501


    Default Re: Making Mapinfo linked table from Access or Excel

    Quote Originally Posted by pl_ev_7 View Post
    @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.

    Please check your PM.

Tags for this Thread

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •