Viewing tables in an SQL database

  • Thread starter Thread starter Andrew Chalk
  • Start date Start date
A

Andrew Chalk

I can connect to my SQL Server 2000 database using "Import External Data"
from Excel 2002 SP2. However, in the "Data Connection Wizard - Choose Data"
dialog no tables appear. The MS sample database "Northwind" shows its
tables. What am I doing wrong?

Many thanks.
 
I'd look at permissions in the database. My instinct would be to assume
that Excel is using a database user which doesn't have any permissions on
your database. Use Enterprise Manager to grant permissions to your user.
 
Thanks. It turns out that if I uncheck the "choose specific tables" option I
can proceed, and then tables and views appear in the next screen. Wierd...
 
Back
Top