Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
reperrotte
 
Posts: n/a
Default Excel 03 DB query pulls data in wrong order, how to resolve?

New user to Excel DB queries. Have set up DB and query, however query does
not import DB in the column-order of the query. This worked fine the past
couple months. Dont understand why it wont work this month. Have re-created
query and the problem still exists. Cant find any information on how to
troubleshoot this issue. Thanks for your help.
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

DataImport External DataData Range Properties
Uncheck Preserve column sort/filter/layout

Does that help?
--
Regards,
Ron

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
How do I set the order of calculation of Data Tables in Excel? Charles Easton Excel Worksheet Functions 1 April 30th 05 10:35 PM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"