Importing data from Excel

J

JKarchner

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.
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top