I'm trying to write an mbx that will take multiple point tables, with different names and from different sub-directories (C:\AKdata, C:\ALdata, C:\ARdata, etc), add the first 2 letters of the table name to a new column called "state", then add "lat", "lon" columns and update those columns accordingly. If any table already contains columns named "state", "lat", or "lon", I still need it to be updated as stated above.
Thanks for the help. -Bob