importing info. from an ACCESS db into Excell

T

Trisha

I'm trying to import info. from an Access table into an
excell spreadsheet and when I try to finish the Query
Wizard and error message comes up saying 'Syntax Error
missing operator in query expression' then gives the
access table name and the first field. Is this an Access
coding error or an Excell problem?
 
T

Tom Ogilvy

It would be hard to tell just based on the error message. If you built the
query interactively, you shouldn't get an error.

Maybe if you posted the query string
 

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 Subscript out of range when importing into access 2010 from excel 0
Access #Error & Excel Pivot 0
carriage return error when importing excel into access 1
Ecell Use of an Access Table information 4
Importing Numbers 2
Updating Excel forecasts into an Access Database 1
importing contacts from excell 1
Want subset of large db table and not load the entire table into access 2

Top