Toby: one option is to import the data to a new (temporary) table, and then write queries to move the data into the appropriate Access tables. If the layout of the data is the same each month, this process can be automated once you work out the details.
Richard "Manxman" Killey Developer of MS Access Databases for more MS Access tips, visit http://www.databaselessons.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Toby Sent: July 23, 2007 3:22 PM To: [email protected] Subject: [Access VBA Central] Excel to Relational Database 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 [Non-text portions of this message have been removed]
