Monday, July 27, 2015

Access Data-Excel Spreadsheets

Distribute to everyone


Many times an office will provide Excel for all users, but not want or need to also install Access on every desk.

Helen Feddema has laid out a method to use the data in an Access database to create Excel workbooks. These workbooks can then be e-mailed to employees to be used to record time spent on projects.

The code provided is above the entry level user, but understandable.

There is a downloadable file that includes the instructions and samples of the Access and Excel files.

Go to Access Archon Columns from Woody's Office Watch.

The pertinent file is down near the bottom of the page. Look for article 127 and download accarch127.zip.



See all Topics

No comments: