Toby use the query wizard. It is easy.
what I usually do is just set up a plain SELECT query using the query build tool (just drag and drop fields) based on the new temporary table that the data was imported to. then, once I am happy that it is showing the right data, I change the type of query to an APPEND or UPDATE query (depending on need) the append query will ask you which table needs to have the data appended and then you map the incoming fields from the temp table to the fields in the final resting table. then run the query and check the results (backup your data base first!!!!) if there are other tables (some data goes to 1 table and some to another) then just repeat. obviously, if there are multiple tables, you will have designed them with the correct common fields (primary keys and foreign keys) so the data can be related in reports later 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 25, 2007 1:42 PM To: [email protected] Subject: Re: [Access VBA Central] Excel to Relational Database 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] > [Non-text portions of this message have been removed]
