Excel spreadsheets are fantastic bits of kit, but databases are not. Rather than making the full jump to replacing Excel with a database system, there is a halfway house you can consider.

Learn how to connect Excel to a SQL database in order to import data into Excel. Then, create a report over the data. You'll need a SQL database first. If you don't have one, see Create your first SQL ...

How to Connect to SQL From VB6. If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential.

Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a spreadsheet application, but an Excel file can also serve as a database for your website if you can ...

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...