I don't want to scan the outside file, since it's a tab delimited text file. I've found a work-around though, by creating an updatable view an appending the file to the view work very well.

Thanks for your response.

>I'd suggest scanning the outside database and insert into your table. I've used a work around before on one-time appends of turning the primary setting of my tag, appending the data, generate the key id, and then resetting the tag as primary.