+ Reply to Thread
Results 1 to 2 of 2

Excel to Access: Updating records

  1. #1
    Registered User
    Join Date
    11-15-2006
    Posts
    1

    Excel to Access: Updating records

    Hi,

    I am trying to design a sort of timesheet system using excel and acess, where my employees will enter their hours worked on particular jobs into the excel spreadsheet, and then update that info into my centralized database. The database will be split into two tables, payhours and jobhours. How many hours each employee worked that week will go into payhours along with their name, and the hours worked on each job will go into the job hours section.

    My problem is I want the database to be able to see if anyone has entered hours for that job for the week, and if not create a new tuple for that job. If someone has already put in hours for it, I want the database to add the additional hours to that job number.


    Example:

    Bob Smith worked 10 hours on job3 and 12 hours on job4
    John Jones worked 8 hours on job2 and 8 hours on job3

    Payhours
    Bob Smith | 22 hours
    John Jones | 16 hours

    Jobhours
    Job2 | 8 hours
    Job3 | 18 hours (8 + 10)
    Job4 | 12 hours

    This is a fairly huge job for me and so any help at all will be greatly appreciated, please reply if something is not clear.


    Thank you

    Alex White
    Last edited by alexwhite; 11-16-2006 at 12:26 AM.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    I tried to do what you asked.
    In the attached file you can see one excel file and one access file.

    The excel file has a command with a macro to write data in the access file.
    In the access file I created only the Jobhours table and not the Payhours because you can obtain it with some queries (see the queries on the db access).

    May be you need to have a table to take the history of hour payments...

    I hope it can help you.

    Regards,
    Antonio
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1