how to prevent MS query from changing the * to field names?
In my Access database (mdb), there's one query which have some fields being changed per Week#. I setup one MS query in Excel to let my users to retrieve all the fields into Excel. I change the SQL of Excel query like "Select * From ..." where * means all the fields are needed, but Excel always change the * to detailed fields names which need me change the Excel Query every week because the week# are changed with time-being.
How to prevent MS query from changing the * to detailed fields name?
Thanks,
Tim
In my Access database (mdb), there's one query which have some fields being changed per Week#. I setup one MS query in Excel to let my users to retrieve all the fields into Excel. I change the SQL of Excel query like "Select * From ..." where * means all the fields are needed, but Excel always change the * to detailed fields names which need me change the Excel Query every week because the week# are changed with time-being.
How to prevent MS query from changing the * to detailed fields name?
Thanks,
Tim