Weekly Data Upload - Need a template - How?
The task is to import several files - each laid out differently - weekly. The layout of the files is repetitive - all importing is from xls files. Each file has several thousand records and about 45 fields. Idealy I would like to create a database with sufficient fields (about 50) to accomodate importing each of these data sources into the same database.
The good news is Import Field Mapping works. The bad news - it only works once because I haven't been able to figure out how to save my meticuliously designed field maps. I can do the save-as-clone-thing but this is inconvenient and risky because the the layout is accidently changed too easily. After my first setup I was playing with options and wound up with f1, f2,f3... replacing my column heads and had to start over again.
The new file data does not replace old file data and if there is a duplicate file it is the old file that must be preserved - not replaced. This eliminmates the recurring import feature.
There must be something I'm missing. Please point me in the right direction.