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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query to import from Sharepoint 0
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Help creating a search form in Access XP 0
Import External Data...Import Data... Error 0
How to recover my old emails from offline data of Outlook? 3
Active Content in this file is blocked issue 1

Top