Hello Whan you import data from SQL you have the query wizard and just before it ends importing data form SQL to excel it asks you to go directly to excel or EDIT IN MICROSOFT QUERY , if you choose editing in microsoft query you can specify and add terms where you specify which data from which table , etc....
I hope this helps. R. M. On Sun, Feb 13, 2011 at 8:45 AM, Manish <paprej...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
