Hi Mike
Your can upload your mapinfo data table to an access db preserving the
mapinfo access to the db. The trick is that your .dat file with the data now
is in the Access table instead of the .dat file. your can now edit the data
through mapinfo, create new objects/data rows. In this way your have only
one (always updated) dataset in mapinfo and in Access.
Rename your original Access table to something like *_old in Access and then
do a save as.. in mapinfo selecting Microsoft Access as your destination
format. MapInfo will the ask for a table name and a db for saving your data.
The other question you can accomplice by using the Insert command in
MapBasic where you can insert both the point/object and the data for the
record at once:
Insert Into customers (Name,Street,City,State,Obj)
Values ("Mary Ryan", "23 Main St", "Dallas", "TX",CreatePoint(-73.5,
42.8))
Take a look in the MapBasic reference for a closer look of the Insert
command.
Regards
Thomas Brix Lyng
Frederikshavn Municipal Administration
Denmark
-----Oprindelig meddelelse-----
Fra: Mayer, Mike @ Vancouver [mailto:[EMAIL PROTECTED]
Sendt: 14. april 2005 21:18
Til: '[email protected]'
Emne: MI-L Linking Tables
Hello Everyone,
I'm looking for a way to link outside tables to MapInfo tables. Basically,
I have an access database and a MapInfo table containing the same
information. Is there a way I can link to the two databases so that changes
in one will be updated in the other?? Also, I am creating a custom geocoding
application, and prompt the user for a new address to geocode, the address
gets geocoded and added to the MapInfo table. However, no information
appears in the MapInfo table, just a blank row at the bottom. How can I
populate the fields, and could these fields that are populated be updated in
the access table as well. Can I do this, if yes, how so?? Thanks in
advance.
Mike Mayer
(GIS practicum student looking for help...)
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16094
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16095
