Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Get Filtered Data from SQL server into Microsoft Excel 2007
This query will work
select code,unitprice from item where code like 'fg%' and u can write this query at Other Data Sources From SQL Query (at the end of the drop down list) next next next Query and then write the query and go into file menu and select export data into excel from there and then select pivot table from given options |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing sql server data in Excel 2007 | Excel Discussion (Misc queries) | |||
copying filtered data in Excel 2007 | Excel Discussion (Misc queries) | |||
Import data from Microsoft SQL Server into Microsoft Excel | Excel Programming | |||
Copying Filtered Data in Excel 2007 | Excel Worksheet Functions | |||
Microsoft Query (sql server)/Excell 2007 | Excel Programming |