Need support for export macro excel to Mapinfo

[rm77]

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.

[Maysam]

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.

[rm77]

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

[kaka.enine]

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

[rm77]

For whom interested here are the steps:
1- prepare your excel table with the appropriate column and open it as tab in mapinfo.
2 -Mapper your table and adjust the projection with Table Structure menue.
3 -On the HOME tab, in the Windows group, click Tool Windows, and click MapBasic from the list, to open the MapBasic window.
4- Type the following command in the window:
update point_table set obj=createline(Start_X, Start_Y,End_X,End_Y).

But still i dont know how tow to creat Mapbasic macro which can exceute these steps with one clic.