| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| access query reports to excel formatting help | New Users to Excel | |||
| Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
| query in excel | Excel Worksheet Functions | |||
| Renaming Access Query used by Excel | Excel Discussion (Misc queries) | |||
| can excel change number 1532 to 1235 running order | Excel Discussion (Misc queries) | |||
Hybrid Mode
