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
LVL 9
Evan CutlerVolunteer Chief Information OfficerAsked:
Who is Participating?
 
PakaConnect With a Mentor Commented:
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
Yep...that did it.
Thanks much.
Evan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.