For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

You don't need additional software or code to create Web pages from data in your Access database. Microsoft Access can create HTML files from its data as one of several export options that allow you ...

The last piece of this three-part article is about merging your custom Word documents with your client list (exported from Outlook to Excel) for distribution. Part One explains how to selectively ...

Did you know that you can export an Access database to an Excel worksheet? In Microsoft Excel, there are features to import or export data from or to an Excel worksheet. When exporting data to Excel, ...