The table name must be determined at the time of import. Save it somewhere can be referenced again later (textbox, global variable, TempVars).


If you sort on the sequence number field in table or query, it cannot be deleted. The table will not retain the order. Again, tables are just a 'bucket'.



If the records are imported in the order of the sequence number then can probably delete the field, however, why not leave it and just ignore it?

Why does it matter what order the records import? This sounds vaguely familiar - haven't we already discussed this?