import external data from Acces into excel

[Klipvis]

Hi I have a select query in my Access database that I want to import in to excel.
When I do this excel comes up with error msg "...Cannot find input table or query 'tPPF'...etc" The tPPF table is in the criteria for one of the fields.

1.The query works fine in Access.
2.Other queries also using tPPF table import without problem into excel
3.If I remove the criteria statment the query import without problem.

the sql for the query:

SELECT tConsignmentResults.*
FROM tConsignmentResults
WHERE (((tConsignmentResults.Month)=(DLookUp("[Month]","tPPF","[CurrentMonth] =True"))));

any ideas why this does not work whould be welcome.
Basically I am using Dlookup to find the current month code in the tPPF table, and then use resulting value to filter the month field.


Klipvis

[Denburt]

I can't give you a definite response except that Excel probably doesn't like the DLookup function.

Try using a query (subquery) for the criteria and see if it works for you it is almost the same as using the DLookup function.

      SELECT tConsignmentResults.*
      FROM tConsignmentResults
      WHERE (((tConsignmentResults.Month)=(Select [Month] from tPPF Where [CurrentMonth] =True)));