Evan Cutler
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks much.
Evan