Access vba import workbook to access using transferspreadsheet what the procedure does is to loop through the workbook and then store the each worksheet name in array namelist then import all ibookread PDF