Importing ordered data on datasheet

O

Olga

Hi,

I'm connected to SQL and I'm importing the results of a query in sheet1
using the syntax ORDER BY. The query and the import are working fine,
however, the data in sheet1 is not ordered as in the query. How can I
maintain the imported order on sheet1?

TIA

Olga

MSSQL05, Excel07
 

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

Need Help with a VBA subroutine 0
Changing data orientation from one sheet to another 13
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Create timeline with event being hyperlinks to documents on drive 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Consistent Sheet column header rows 2
Embed the same Excel multiple times 0

Top