What is the best (or easiest) way to import a set of records each week and include a custom date in a field not part of the import set?
I have a weekly record set of 75 fields and several thousand records. I am using the LOAD command. Previously I thought I would just DELETE the current data and LOAD the new data. Now I have learned that I need to keep the old set(s) and so it appears to me that if I add a date field in the table then a plain date (12/17/2008, for example) would be sufficient to distinguish each timed import. No need to keep a time signature also. I thought to just add a field at the beginning or end of the table but that would throw off my import because the imported data doesn't have that field. I would like to be able to enter the date at some point of the import process. Something where it asks for the date to be used and then assigns that to all the records that are imported in that batch. That way I can add previous record sets. Also, how do I duplicate a table? I need to test the record sets before I import them. Thanks for any suggestions and pointers! --- Hans Manhave Operations Director Jackson-Lloyd Ins P.O.Box 187 Longview, TX 75606 903-758-6206
