[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

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
0
Evan Cutler
Asked:
Evan Cutler
1 Solution
 
PakaCommented:
0
 
Evan CutlerAuthor Commented:
Yep...that did it.
Thanks much.
Evan
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now