Results 1 to 2 of 2
2007-09-27, 16:00 #1
- Join Date
- May 2004
- Asheville, North Carolina, USA
- Thanked 0 Times in 0 Posts
Spreadsheet to Database (Office 2003)
Attached is a spreadsheet that I am required to use but would like to convert over to Access. The reason is that Excel limits my ability to calculate information the way I need it. I would like to have the information calculated on a revolving year. As you can see some of the calculations are based on 6 months of info while others is based on a year.
My question is can someone point me in the right direction to covert this info over to a Access Database and be able to maintain info based off of spreadsheet formulas.
Thanks for any help or guidance.
2007-09-27, 16:35 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Spreadsheet to Database (Office 2003)
Excel is much more flexible than Access when it comes to calculations. It should be possible to modify the workbook to use a revolving year whatever that may be <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
The strength of Access is that it can handle larger amounts of data, and that it allows you to create relationships between tables much easier than Excel. But that doesn't appear to be involved here.