Pre-school register

[shaunhayter]

Help! I am trying to think of a way I can use an excel worksheet as a data form in Access. A little background to the problem. A pre-school that I have been helping have a excel spreadsheet in place that they use as a kind of booking register which also works out the termly costs for each child based on the number of sessions attended. Is there any way I can inport or link this to a database so monthy invoice's and goverment figures can be printed automatically.

 

[rsmonkey]

indeed their is you can do both import or a link table. Once you've imported the data I would then create a VBA script to count the amount of sessions a child has attended and then in turn times the by the cost. This can then be put into a report etc...

Its very possible & not too difficult what you're asking but it depends on how intricate you want these reports that will affect your design. I.E if you want to have time and place for each child on each session then this will affect your database design etc... oh and it also depends how badly/well designed your excel spreadsheet register is aswell