Quote Originally Posted by OBP
Mike, I have looked at your 3 queries and they are good, so I am going to use something very simliar to update a "PriorityCode" field which once set can then be used for the Grouping in your Summary.

What data do you need to store "Long Term", all the data Imported?
Just the data relevant to the Summary?
It may be too difficult to create a "Global" Import that will work with any File structure, unless I can remember how to recreate my old VBA code for Mixing and Matching Headings.
It might be better to have a routine "Setup" for each version of Import for now.
Long term storage of data is something I havent really thought about. I dont know that it will be necessary. Up to this point the data has beem needed again one the analysis has been done.

I can probably just map the fields in the current file to those in the database. I cant really think of another way to do it.