I have a linked Excel file (I can't change) I have created a crosstab table from that. The Crosstab table works great. And then I have a simple query that reads the fields from the crosstab. Now here is the problem. The data that the crosstab reads changes. (Remember I have no control over that Excel file)
So one day I have 5 fields in the crosstab and the next I only have 4 fields. But the query won't work because it's set up for 5 fields and gives an error message doesn't recognize field XXXX as a valid field name.
Anyway to fix this problem ?