Perform same queries on different tables

[aTmchick]

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?

 

[Pat Hartman]

Unless there's a limited set of spreadsheets, you'll need to create the SQL in VBA for each situation. If you have a multi-user database, be careful with this since you won't be able to have the db opened by multiple users if one of them changes any objects such as tables and queries. Only data changes are supported by Jet when the db is opened by multiple users.