Excel 03 DB query pulls data in wrong order, how to resolve?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Data>Import External Data>Data Range Properties
Uncheck Preserve column sort/filter/layout

Does that help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Query setup 0
Excel 2k3 query path to current directory 1
Specifying filtering criteria for ms query in excel 1
importing/linking data from an Access 2003 Query to an Excel 2003 2
Too few parameters error with a IIF statement 5
Applying Criteria in Excel Cell to MS Query Pull from Access 1
Excel 2003 randomly loosing database queries 1
Access Access 2007 DB reaching 2GB limit and Transform query 0

Back
Top