Hi

Apologise if this is posted to the wrong group.

I have a query set up in an access database and I would like to pull the
results into an excel spreadsheet. I am trying to use External Data Source
and have managed to connect to the database with Microsoft Query.

I tried using the wizard but I couldnt get the result I was looking for. So
I tried it manually and entered the following SQL into the SQL Text box in
Microsoft Query:

SELECT qryMergedTopSuppliers.Vendor, qryMergedTopSuppliers.Descr,
qryMergedTopSuppliers.ABC, qryMergedTopSuppliers.Description,
qryMergedTopSuppliers.SumOfAmount
FROM qryMergedTopSuppliers;

And I get the message 'Could not add the table qryMergedTopSuppliers' am I
missing something here?

I also tried using so SQL from some of my existing queries but these all
brought up errors as well? Can anyone help with this problem or point me in
the direction of some resources?

TIA

Edgar