Results 1 to 2 of 2
  1. #1
    Star Lounger
    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.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts