Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Using Excel to Pull Data from SQL Server


 Article Abstract:

(Michael Schmalz) This article describes a method to allow a general purpose recordset pull from SQL Server and dump the results into Excel. This is different from the other Excel articles I published here because it is a pull of data instead of SQL Server pushing the data into Excel.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Optimization Tips for using ADO with SQL Server
Use an ActiveX Script in your DTS Package
What To Do When you need to compare databases.
ASP Optimization Tips
End-to-end Automation with IBM Tivoli System Automation for Multiplatforms
Diagnosing Poor Data Access Code Using SQL Profiler
Using DTS to Automate Excel Data Refreshes
Tips for using Access as a front-end to a SQL Server database



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004