I have a sheet in excel that is formatted like a table in access. Using a macro in Excel I need to upload the tables contents to a table in access. I can't upload from Access, it has to be from Excel.

I have figured out how to do it one record at a time but not the entire sheet.