The Connecting to Database window will appear first, ... Click and select the table in the data source that contains the fields you want to query with SQL and import into your Excel spreadsheet.

A new query window opens and displays the tables from your SQLite database. Highlight and select the table containing the data that you want to import into Excel, then click "Close." Click the ...

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 ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

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.