Found a fast way to append large table into another

82 views
Skip to first unread message

Ross Nixon

unread,
Nov 14, 2023, 9:53:47 PM11/14/23
to MapInfo-L
This hint may help some people:

I had two very large tables that I wanted to combine.
AppendAll.mbx couldn't work due to columns not matching.
After making the table structures match, copy & paste just tied up my PC for ever, and made the clipboard unavailable for anything else.

Solution: Use the Mapbasic window with a command similar to this, depending what columns are involved.
Insert Into DESTINATION_TABLE ( COL1, COL2, COL12) Select COL1, COL2, COL3 From EXTRA_DATA DropIndex Auto

-- This was near instantaneous.
- MapInfo 12 or 15.

Uffe Kousgaard

unread,
Nov 15, 2023, 1:10:23 AM11/15/23
to mapi...@googlegroups.com
Hi Ross,

Table > Append rows to table does the same thing and you don't have to type all the field names.

Regards
Uffe Kousgaard
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/2ce6c852-8bb9-4fe3-9eb3-c5098464e52fn%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages