Bringing in data from Access

T

TeaCup

I have been trying to import data from an Access (97)
database query into Excel (97) from the Data pull down
menu; Get External Data; Create new query.

When ever I point to the query in the database I get a MS
Query error stating "Syntax error in FROM clause" which
states that the error was returned by the driver. There
was no FROM clause in the query, also I have tried it with
a table and got the same error.

Can anyone help?
 
Top