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 PostGoogle!
Lots of hits, for example http://www.dicks-clicks.com/excel/ExternalData.htm
or http://www.oraxcel.com/projects/sqlxl/help/techniques/query/ etc.
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.