What's the best way to routinely grab data from csv files with different names in a directory folder and append those rows to an Access table? The csv's have the identical field names to the Access table.
That's a little open-ended. TransferText and TransferSpreadsheet are common ways of importing data. To do it on a schedule, I'd probably create an MDB that performed your imports when it started, then quit. Then I'd call that MDB from Scheduled Tasks as appropriate.