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...



"joel" wrote:

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" wrote:

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" wrote:

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" wrote:

Whoa, you lost me there completely!

"Ron de Bruin" wrote:

Hi Andy

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Andy" wrote in message ...
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