General discussion


Excel to Access; or both?

By bfennelly ·
Have (complex) calculation worksheets. 1 sheet for data entry, 1 for 2 page report including all caculations. The report data entry is sent to another file for storage of all previous data. This file now has 7500 rows and 30 columns of records and takes a long time to retrieve and sort data. Should I try to duplicate the whole thing in Access (don't know how to do this quickly), or should I leave the calculations and output reports in Excel, leaving only the records in Access? Can I then queryfrom Excel withouit having to open Access?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel to Access; or both?

by acwiz In reply to Excel to Access; or both?

Import all you data into Access. You can run Pivot table reports in Access which takes you to Excel. You can do all your record gathering in Access and export to Excel. Access is great for keeping information and Excel is great for calculating accounting type data. Use both.

Collapse -

Excel to Access; or both?

by bfennelly In reply to Excel to Access; or both?

Related Discussions

Related Forums