I'm working on this for a friend, so let me even see if I know enough to explain this.
I need to perform the same queries on any table that is imported into the db. The queries pretty much compare the data in the table to data that was in the table yesterday and gives a list of what is different.
The thing is, I would like to apply this to any table that is input (from an excel spreadsheet). They will have different field names.
How can I refer to the field names in queries if they will be changing?
I need to perform the same queries on any table that is imported into the db. The queries pretty much compare the data in the table to data that was in the table yesterday and gives a list of what is different.
The thing is, I would like to apply this to any table that is input (from an excel spreadsheet). They will have different field names.
How can I refer to the field names in queries if they will be changing?