Trying to import data from Access 97 using Excel 97

H

Hawk

Not sure whether to post this under Excel or Access (I
will try both)...

I am trying to query an Access 97 database from Excel 97
by selecting:

Data -> Get External Data -> Create New Query

From the Query Wizard, I am able to see the tables within
the database, but not the fields. I am assuming it must
be a permissions problem. I have given the Users group
Open/Run permissions to the database, and I have given the
same group Read Data & Read Design to the tables. Any
ideas would be greatly appreciated...
 

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

Adding data to MS Access from csv file 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Linking data in MS Word into Excel 5
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Problems importing "number/text" fields to Access from Excel 2
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Import Excel 2010 table into Access 2010 - not listed as range 0

Top