How to move data from sql server to excel sheet.
nayansaurabh 0 Newbie Poster
Recommended Answers
Jump to PostYou can do a DB query from excel, see the Data menu.
Jump to Post>How to move data from sql server to excel sheet.
Use OPENROWSET command (SQL Server 2000 and SQL Server 2005).
All 5 Replies
ddanbe 2,724 Professional Procrastinator Featured Poster
You can do a DB query from excel, see the Data menu.
nayansaurabh 0 Newbie Poster
how to use a DB query from excel. what is data menu
ddanbe 2,724 Professional Procrastinator Featured Poster
Google!
Lots of hits, for example http://www.dicks-clicks.com/excel/ExternalData.htm
or http://www.oraxcel.com/projects/sqlxl/help/techniques/query/ etc.
kvprajapati 1,826 Posting Genius Team Colleague
>How to move data from sql server to excel sheet.
Use OPENROWSET command (SQL Server 2000 and SQL Server 2005).
nayansaurabh 0 Newbie Poster
How to move data from sql server to excel sheet on the click event of a button.
How to move data from sql server to excel sheet on the click vent of a button
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.