Thank you very much for your help. The remaining problems that I am havin are as follows:

1. Once I've loaded data into the temp table I do not know how to do appropriate changes to my table data and load into one production table or multiple production tables.

2. Do not know how to write a sql statement and copy data from temp table to production tables.

Thank you in advance for your help.

Nedpan.