Excel/MSQuery/AccessTable Conundrum...!

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I have an XL2000 spreadsheet and want to connect a worksheet to a
table in an Access 2000 database.
I am trying to connect via MSQuery (DATA > GET EXTERNAL DATA > NEW
DATABASE QUERY)

After navigating through the dialogue boxes to the Access DB I want, I
get the error message "This data source contains no visible tables'.
However, I am easily able to open the Access database and view the
tables (the Access DB is NOT secured nor is set up for multi-user
etc).

Can anyone help out with what I need to be doing to hook this table up
to my spreadsheet?

Many thanks to those who respond.

Cheers

P
 
Hi Debra,

Many thanks for the pointer - I'll check this at work on Monday morning.

Thanks again,

Cheers,

phil
 
Back
Top