View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Andy is offline
external usenet poster
 
Posts: 414
Default Import Data from Access query

I have an Excel (2003) spreadhseet and am trying to automatically import data
from an Access (2003) query. Data import External DataNew Database Query.

However the order of the columns in the crosstab query are important and
they do not replicate the order in Excel as they are in the access query. How
can I specify what order I wish them to be in within Excel so that it matches
the Access query structure?

Thanks