Sunday, July 03, 2016

Export Formatted Sheets

Access to Excel

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 will include some minor formatting that are applied to the field headings in row 1.
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; however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state.

In Office 2007-10+ it's External Data>Excel

See all Topics

No comments: