Connect to the database We tried this using MS-SQL 2000 Server for the database and Excel from MS Office XP. To query the database, start Excel, go to the Tools menu and click on Add-Ins. Now ...

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to ...

Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a ... You define the connection using an ODBC connection string. Type the SQL query for the data ...

Instead of just importing static snapshots of your database information into Excel, SaveToDB allows you to directly connect to live databases like SQL Server, Oracle, MySQL, and many more.

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

For example, you could query to find and extract all records that contained sales greater $1000 but less than $5000—but only on flat files (only one database matrix).