Import Data from Access query

[Andy]

I have an Excel (2003) spreadhseet and am trying to automatically import data
from an Access (2003) query. Data > import External Data>New 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

 

[joel]

when yo uperform the query the 1st menu after you choose the database
contains the tagbles in the database. Press the plus sign. then choose the
columns you want one at a time in the porder you want them to appear in the
excel spreadsheet.

 

[Andy]

This worked on the query that I was looking at, but not another :-(. Neither
clinking the + to expand, nor > to move all fields over from the query show
any columns at all. It's almost like the query has no columns!

 

[Ron de Bruin]

Hi Andy

Is ADO working correct for you ?
http://www.rondebruin.nl/accessexcel.htm

 

[Andy]

Whoa, you lost me there completely!

Hi Andy

Is ADO working correct for you ?
http://www.rondebruin.nl/accessexcel.htm

 

[joel]

Ron was refering to a macro. Try opening up the database and see what is
really in the database with Access. Queries will return data not objects.
Make sure there is text data and not pictures or other objects in the
database. The database may have a password.

 

[Andy]

Forgive me if I'm not grasping the right end of the straw. I;ve downloaded
the database and there is only an Orders table with 700 odd rows of data, no
macros or anything else???

 

[joel]

You are fine. Performing a query from the worksheet if it gets you the data
you need thats great. Excel has a programming language (VBA - Visual Basic)
that can be uised to to enhance excel. Ron was refering to these advance
features. You don't need any advance features for your 1st database.

At the moment I don't know what you 2nd database looks like and why you are
having problems. that is why I recommended opening the 2nd database and see
what tables are available and the Columns that are available. it is easier
to open the datqabase and see it then to use the excel Import external data
method. Once you see the data in Access then it will be easier to design a
query to download the data.

 

[Andy]

Thanks, I guess the bottom line is why can i not write this query to get the
data from Access? I can run the query in Access and can see the data and I
can import data from other Access queries in my same database...