Easily create formatted Excel sheets from Access data (97/2000)

Access provides an easy way to export data to Excel through the Office Links feature. To use this feature, simply select a relevant database object and choose Tools | Office Links | Analyze It With Excel. The worksheet Excel creates includes some minor formatting applied to the field headings that appear in row 1. However, you should be aware that some formatting in your original Access database affects the worksheet cell formatting as well. For example, if you're exporting from a datasheet, gridline and font attributes are carried over to Excel. If you use the Office Links feature to export data behind a form, text box shading and font properties are applied. The final result in Excel may not exactly match your Access data (for example, colors may get changed and bold formatting is lost); however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state.

Created Date: 12/10/2001  Last Reviewed: 12/10/2001  Rev. Date: 

This site was last updated 06/11/06