Hi Ryan
Yeah, that would be easy to do. But there are always those tiny tweaks where a table has a different column structure or order of the columns...
But you are right. We should have such a tool.
For now, you can use this elementary method:
1. Open the tables you want to merge
2. Paste the two lines of code into the SQL Window and execute them until you get an error
Insert Into TableInfo(1, TAB_INFO_NAME) Select * From TableInfo(2, TAB_INFO_NAME) DropIndex Auto
Close Table TableInfo(2, TAB_INFO_NAME)
This will insert the second table into the first table and then close the table. Continue doing this until you only have one table open.
You can also use the MapBasic Window. Paste the two lines into the MapBasic Window, select both lines, and hit Enter until you get the error.
The error occurs when you only have one table open.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 01-23-2023 11:03
From: Ryan Richter
Subject: Multi Append Tool?
Is there an updated version of a Multi-Append tool mbx out there somewhere? I have an old multiappend.mbx file that I registered but cannot get to open or work with the latest version of MapInfo, and I did not see any mbx tool like this in the MapInfo Marketplace.
A colleague of mine showed me how to do it in Q-GIS which came standard in that program, made me wonder why something like this is not standard in this day and age in MapInfo. Seems like a pretty easy and common thing to have in an advance GIS software program like MapInfo, but it's not.
I have to append about 25 files, and there's not way I want to do the manual 1 at a time way which is the only option available that I can see.
Thanks
Ryan
------------------------------
Ryan Richter
COX COMMUNICATIONS
Roanoke GA
------------------------------