Import from Excel chart

[Rosemary]

Hello,

I have a table in my database that holds the number of hours worked by each
employee each day (EmpTime). There is a small form in the database which
asks for their name, the date, and the number of hours worked that day. This
information in this table is used in running statistical reports.

This same information is also provided each week by the employees when they
do their weekly time reports in an Excel chart form. There is a TOTALS
column in the chart which calculates the number of hours worked each day that
week.

Is there a way I can import the daily TOTALS from the employee's weekly time
report and put it into the EmpTime table?

Thanks,

 

[David Seeto via AccessMonster.com]

Is there a way I can import the daily TOTALS from the employee's

weekly time report and put it into the EmpTime table?

Yes, but you want more than just the daily totals in each records, you'll
also need to find the name from the spreadsheet somewhere. I'd say you'd
need to wrap some code around the actual importing to get this done -
unfortunately, I'm not very familiar with the VBA side of things: try
asking over in the Forms Programming section of the forum...