Help with bulk loading some data

Hi, I have a VB application that is basically a payroll or timesheet type of program that uses access as the database. I am going to need to add each employees standard work hours Monday to Friday for the next several months all at one time to avoid doing this manually though the application. So what I need is a macro or something that will add only info for a few fields like Start time, End Time, employee, employee number and date. All these fields are the same each day of the week for each employee, except for the date. Problem is that I need the date to move to the next day and add each record but I also need it to exclude weekends. Anyone have any ideas?

Thanks

Sherriff

It is better to have a table for Shop Calendar
eg. a table named SCL with fields
ThisDate Datetime
WorkingDay Boolean
Counter Long

and append the table with all the 365 dates in financial year with true status to workingday initially and afterwards update workingday field with false for sundays and holidays. Now create a loop counter which will increment only on working days and update this series to counter. Now you can pickup the next working day from this table at any time for a given date by looking at counter field and incrementing its value to one. If i am not clear just tell me I will reply in detail.