Importing data from Excel

[Guest]

I read that Access does not have the ability to import data from multiple
worksheets at once. Is this true? I have 9 separate excel files, and each
one has a worksheet for everyday of the year (this is how our timesheets are
setup). Each employee has his/her own excel file. My boss requires a
monthly breakdown of each employee as well as breakdowns for projects. Each
sheet only contains about 7 or 8 entries. So copying and pasting this data to
a separate excel file is a long and tedious process, and importing the data
one sheet at a time would be equally as long and tedious. So i would like to
import from many sheets at once, if it is possible. If anyone can provide
any help, or a link with additional info it would be greatly appreciated.

 

[Guest]

Not all sheets at once, but it is possible to import each sheet. You can
specify the sheet to import in the Range argument of the TransferSpreadsheet
method. The name of the sheet is what you see in the tab at the bottom of
the worksheet.