Thanks Thanks:  2
Showing results 1 to 4 of 4

Thread: Need support for export macro excel to Mapinfo

  1. #1
    Senior Member Reputation: 249
    Join Date
    2010-09-27
    Posts
    254


    Default Need support for export macro excel to Mapinfo

    Please could any support me how to creat a line and point in Mapinfo to represent a MW link with its differents parametres (Freq TX RX , RX level , TX level ....) from Excel database.
    Now i'm used to do somes macro with VBA and i want to adjust such table to Mapinfo.

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Member Reputation: 188 Maysam's Avatar
    Join Date
    2012-07-05
    Posts
    141


    Default Re: Need support for export macro excel to Mapinfo

    because of TAB file format, it is not easy to do it directly from excel, i suggest to create kml file from your table then import to mapinfo or convert kml to tab file easily.
    also there is an option to write MBX file to create links directly in mapinfo from imported excel file.

  4. #3
    Senior Member Reputation: 249
    Join Date
    2010-09-27
    Posts
    254


    Default Re: Need support for export macro excel to Mapinfo

    Dear Maysam;
    Please would you mind to guide me how to write sush MBX directly in mapnifo from excel import.
    Thanks in advance.

  5. #4
    Senior Member Reputation: 363
    Join Date
    2008-05-22
    Posts
    850


    Default Re: Need support for export macro excel to Mapinfo

    using bellow script in mapinfo,

    update point_table set obj=createline(Start_X, Start_Y,End_X,End_Y)

    point_table = your table name
    Start_X = Long Site A coloum name
    Start_Y = Long Site B coloum name
    End_X = Lat Site A coloum name
    End_Y = Lat Site B coloum name


    put any information you want inside the excel, it will appear in line information you created before
    والسلام عليكم ورحمة الله وبركاته & Regards,

    -kaka-

  6. Thanks william.dg08, ssmc thanked for this post

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
  •