Viewing tables in an SQL database

[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.

 

[Bjarki]

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.

 

[Andrew Chalk]

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...