Hello, I am wondering if there is a way to automate the import of a small range of cell data from excel into and access database table. I need to capture monthly totals for 12 different catagories of hours worked, but this is a very small portion of everything in the workbook/spreadsheet. I need this for 50 employees this access table will then be exported to the Agency Finance Office
Sami Shamma
@Reply 2 years ago
There are different ways to do this depending on the design of your spreadsheet.
Perhaps the best if it is possible is: Link to Excel
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
