Can you duplicate an existing table with over a hundred fields to create smaller catagorized tables by deleting unwanted fields. I hope I made that clear.

The Tramp

Yes with a version of your tool postfixed Adv. is it a pretty straight forward task to perform.

But a table with 100+ fields is indeed crying out for some kind of structure approaching a certain level of normalization. Which it fortunately seems to be the direction your efforts seems to take you - a step I only can encourage!

But I can only say that doing this by, imports might be the answer in you present case, but a purchase of the Adv. seems an obvious decision, because what you are about to do, would benefit from a more appropriate tool.

--sd