I am sure this has been covered before but I cannot find exactly what I need, which is simply to create and populate an Access table from an Excel sheet i.e. using the field names from row 1 of the Excel sheet and the data from subsequent rows. I need this to run from within the Access environment.