Thank you so much, this is way above my head but I will copy your example and work with it. When I see stuff like this I realize I...

Thanks for your help.

Just the contacts. This is an example of what I have in the EventContact table

Project Number ContactName ContactType

1 ...

Thank you I will try to post according to the format suggested in the article.

Peter I just want to assure you that it will work in your SQL2000/Excel2003 environement. I've used the Get External data feature of Excel with SQL7, SQL2000 and SQL2005....

I am in a very large company 20 billion in sales and I am writing queries on the performance in call centers and I don't have an issue with things...

You can either link the SQL tables into your database or create SQL-pass through queries but since this is a discussion about using External data in an Excel spreadsheet I'm...

I sometimes use MS Access as the data source for Excel and the only difference is that you select MS Access database as your data source instead of SQL Server....

I have a management background and in my later years learned computers using Access. I started with Access 1.0 the first version Microsoft ever realized and today as a...

Thanks for the information but I do not use stored procedures and I'm wondering why you feel this is necessary. I base the spreadsheet on specific views and then...

I have been using this for about 10 years for management reports but I don't allow the users to create their own queries because most users are not technical enough...