Imported data query doesn't reflect database

J

JD

I have a simple query in an AccessXP database:

SELECT COUNT(*) AS recs FROM myTable WHERE material
LIKE '*carbide*'

In the database this works fine and returns the total
number of records that match. When imported into ExcelXP
the number returned is always 0. I tried this on another
machine with Office 2003 installed and I don't even see
the query as an option when I am prompted to select the
data to import, instead all I see is the original table
and an error table (which I can't find anywhere within the
database). What could be causing this?

Thanks,
Jacob.
 
Top