Thank you for the answer. I can certainly pull the data into a single table, but can you please show me where I can find an example of a query to put the data into the appropriate tables (and have them relate)?
Thanks again for your help. Toby --- In [email protected], "Richard Killey" <[EMAIL PROTECTED]> wrote: > > 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] >
