Hello,

I am using an Excel Data Query to grab some data from a CrossTab query in
Access. The crosstab query has userNames in the rows and YR-Month in the
columns with Number of Sales in the Results. So as the year goes on, columns
keep getting added as we hit new months. The problem I am having is that
when I link to the Access query, it returns the months we have so far. But
it doesn't add new columns into the excel data when I refresh. When I go in
to EDIT QUERY and view the SQL, I have tried changing the SQL to SELECT
qryname.* so that it would just include all fields. This immediately changes
the SQL to just include columns that currently exist. Is there any way to
make this work with Excel data queries? I have numerous queries I need to
grab data from and don't want to have to refresh them each month to add the
additional fields.

Thanks in advance for any advice!