Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL View output to Excel

Status
Not open for further replies.
dreameR25

dreameR25

Programmer
Aug 5, 2002
35
US
Hi guys,

Could someone help me write some code that would allow me to list the names of SQL Server queries in an Excel datasheet then press a button which would then load the content of each view in to a new datasheet?

I've been surfing the web for help for the last 4 hours and have found nothing of any use!

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
973
remeng
remeng
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
765
huiettcm
huiettcm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
676
mikrom
mikrom
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
447
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top