I want to import data from SQL server 2005 into Excel 2007 using
Data=>from other sources=>From SQL server. I am able to import
complete table (e.g. Item) but there are too many unnecessary fields
as well as records which also get imported. I want to filter the data
before importing into excel but don't know how to do that? For e.g. I
want to import "item" table with only the records whose item code
starts with FG and only "code" and "unit price" fields.

Can anybody help me out in this regard?

Manish

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to