Posted 26 August 2012 - 03:42 AM
once you've created the table to hold the scheduling slots, you can create the data to fill it in Excel, using copy & paste/copy down/fill down/whichever method you like. Then you can copy and paste append it into the Access table. Alternatively, you can write a VBA sub to create the records using some form of looping process.
I'm not what you mean by, "have the table automatically filled out". Which table? Do the records magically appear out of the aether? (I'm sure that some of my users think that, but that's a whole other rant.) If your scheduling data is coming in from a spreadsheet, then yes - you can write processes to pick that up and use it to create records in Access tables. It's how I populate a couple of databases.