Fields change order from MS Query to Excel
If he is running/controlling te Query by an Excel Macro, then perhaps the
macro is re-ordering the columns.........one can actually completely format a
report during this process.......to include re-ordering, hiding, etc.....
hth
Vaya con Dios,
Chuck, CABGx3
"maryj" wrote:
Client is using Office 2003. He has a query created in MS Query pulling from
Access database. When looking at the SQL statemenet and running the query
within MS query, everything looks as it should. When query is sent to Excel,
the field that is listed 1st in the SQL statement is displayed last kin
Excel. Any ideas what might cause this change?
--
maryj
|