Viewing tables in an SQL database

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

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

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

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

external data doesn't show all data... 4
Problem mysql import in powerPivot for Excel 2010 1
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
import nultilinkage sql table into excel 3
writeback to SQL 2005 2
how do I import data in excel form SQL server? 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Top