Enter your email address:

Delivered by FeedBurner

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page








Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker
  Web http://www.klippert.com

  Sunday, July 03, 2016 – Permalink –

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

Labels: , , ,

<Doug Klippert@ 3:33 AM

Comments: Post a Comment