I am inporting an Access Crosstab query into excel, and then doing some vlookups on the imported data. Everything works great unless an additional item is added to the crosstab query...then many of my vlookups are incorrect because the items I want are not in the same places anymore. I would like to import the crosstab query column headings so that I can find my data based on the column heading regardless of whether the query has changed or not. I currently use the attached sequel string to import the query. I use an * because picking individual items does not work.
BrineSompositionSequelString = "Select *" _
& " From qryBrine_Crosstab" _
& " ORDER BY BrineDetails"