In Access, Click on File/get external data and select your Excel Worksheet.
Follow instructions on Screen. This will create a table in Access.
If it is a regular monthly requirement you may consider VBA code to do this.
tj
Toby <[EMAIL PROTECTED]> wrote:
I have (and will be getting monthly) Excel reports. I need to suck
that information into my Relational Access Database for running
queries, and making reports.
The information in the Excel reports includes Personnel Number, Last
Name, First Name etc., and the hours they worked under specific charge
codes.
What are some options for bringing this data into Access? Can it be done?
Thanks,
Toby
Janardanan Therampath [TJ]
13171 All American Road
Fishers, IN 46037
317-773-6216 Home
317-439-3441 Cell
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!
[Non-text portions of this message have been removed]
