We help IT Professionals succeed at work.

Filter connection between Excel and SQL Server

Greetings,
I was wondering,
I read a SQL Server table using EXCEL 2007's Get External Data function.
The table is getting larger and larger in SQL Server.
Is there a way to filter the result set from SQL Server PRIOR to populating EXCEL?

Thanks.

Evan
Comment
Watch Question

Commented:
Evan CutlerVolunteer Chief Information Officer

Author

Commented:
Yep...that did it.
Thanks much.
Evan

Explore More ContentExplore courses, solutions, and other research materials related to this topic.