Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing sql server data in Excel 2007 joker197cinque Excel Discussion (Misc queries) 0 October 7th 09 04:24 PM
copying filtered data in Excel 2007 mlc Excel Discussion (Misc queries) 2 January 7th 08 08:24 PM
Import data from Microsoft SQL Server into Microsoft Excel Joe K. Excel Programming 0 September 29th 07 03:40 PM
Copying Filtered Data in Excel 2007 Chgofan Excel Worksheet Functions 5 September 26th 07 07:06 PM
Microsoft Query (sql server)/Excell 2007 Johnslg Excel Programming 1 May 17th 07 09:47 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"