SQL Excel
Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Firebird and any other ODBC compliant database
SQL Excel Overview
- Freeware Excel Add-in
- Easy to import data from external data sources for further analysis within Excel
- Works with ODBC compatible data source: SQL Server, Oracle, Sybase, Access, MYSQL, FireBird, DB2 etc.
- Excel 2000, 2002(XP), 2003 and 2007 Compatable
- Fast and easy to use
| How to Setup up a connection to SQL Server (Flash demo) |
|
|
| Monday, 12 May 2008 | |
|
This a short video clip of how to use SQL Excel to setup a connection to SQL Server. The example connects to the northwind example database using windows authentication on a local server but the process is the same one for remote databases or other database provider types. One other thing is that you can setup your connection manually by typing (or pasting) in a connection string. But the easy way is to use the Data Link form. When using the Data Link form, it is a very good idea to use the "Test" button so you know there is no problem with the connection. The video content below requires a Macromedia Flash Player. If you don't have one and still wish to see the video, you can download the latest version of the free Flash Player here. If something is not clear with this demo, please let me know. I wil be uploading more videos like this as I can. Thanks, Al
|
|
| Last Updated ( Sunday, 25 May 2008 ) |
Delicious
Furl it!
Spurl
NewsVine
Reddit
YahooMyWeb| < Prev | Next > |
|---|