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
