BillPiper:
Thanks but it doesn't give me this option if I am importing to an existing table, only if I create a new table every time.
That's not accurate Bill. I suspect you haven't read Smiley's comment carefully enough.
When you do an import manually, whether into a new table or an existing one, you get the opportunity of specifying many details about the import. You also get the opportunity to save this
Import Specification for reuse at other times. If you do that, then any future imports can be made to use that named
Import Specification, and thereby follow the way you have set it up.
Does that make the situation clearer?