Table name as parameter in SQL query
Seems to me that you could import to a single table, then update the master
table from there. If there are errors you can always delete a single months
transactions from the master table. No need to store each month in a
separate table and in the master as well. It sounds like you are keeping
the monthly text files anyway, so you could always go back and redo the
entire process.
Dale
|