from excel to access

[waymond]

I have a non profit excel sheet I need to convert to access.
it has 12 different organization auxillaries. The first column has the previous month ending balance then they enter the amount raised this month into column then it has calculated column total raised that is the sum of the brought forward and raised this month column then they enter what was disbursed into a column and the final column shows end month balance.

They are able to open any month and see the previous month balance. For example if they opened up july the first column would have the ending month balance automatically populated from june. IS there anyway to set up table in access that could do this? How many tables and what structure would I need?

Thank You

 

[WildHare]

IMHO, this is not a good candidate for conversion to Access. Excel (or any spreadsheet) does this kind of thing very easily, what with the automatic recalculations of formulas and such. A database is not designed to do this, within reason.

What you COULD do link to this Excel spreadsheet (READ ONLY) for use in display forms or reports, but you would not have any WRITE capabilities.

Perhaps if you tell us why you "need" to convert it to Acesss we can help out with other strategies.





--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman

 

[GingerR]

Maybe you didn't like my previous response?

Duplicate Post: thread700-1293635

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html