Designing a database application from minimal description is a rather tall
order for a newsgroup question. The project costing database applications
that I have seen obviously required hundreds of hours of design and
development, and perhaps well into the low thousands of hours. They were, as
you might guess, proprietary property of the companies that had them
created.
If your Excel data is arranged in "tables" of rows and columns, related to
each other, it will be relatively easy to link to the Excel spreadsheet and
run maketable queries to create Access tables with the information. But if,
like most spreadsheets, it is not in that kind of order but a combination of
individual cells, with many formulae, by project with lines for various
expenses and individuals, it's going to be something of a chore.
It sounds as if you are not experienced in database design and
implementation. You might want to do some basic study in those subjects
before making your "make or buy" decision about this application. Google
this newsgroup on "books" for some recommendations on where to start
studying.
Larry Linson
Microsoft Access MVP
"poohnie08" <po*******@yahoo.com.sg> wrote in message
news:8a**************************@posting.google.c om...
I have an excel worksheet which display staff hours spent for certain
projects in a monthly basis (running calendar day 1 to end of the
month including sat and sun). I hope to use ms access and designing a
database which will incorporate all the fields inside the worksheet
for project costing analysis program. How do I make this database
incorporate all of excel information, and give me the proper history
on each project eg. how many man hours are spent on certain projects?
who are the staff who work on certain project ? I hope this question
is framed correctly. Thanks.
I have the excel worksheet with me (feb2004.xls) about 400kbytes. If
anyone who is keen to help, pls send email to po*******@yahoo.com.sg
linda.