Fields change order from MS Query to Excel
 

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

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

Fields change order from MS Query to Excel
 

No macros, no VBA
--
maryj


"CLR" wrote:

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

Fields change order from MS Query to Excel
 

I had the same problem and its confusing.

When you use the SQL you are aware of the SQL file youre using.

When you put the data into the Excel file you are very likely pulling
another SQL file thats similar but not the same.

Try a new Excel workbook with a new sheet and open the saved SQL you want.

Make sure its the same by re-naming the SQL file to something new and make
sure you load it.

Good Luck.

--
Richard


"maryj" wrote:

No macros, no VBA
--
maryj


"CLR" wrote:

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