IMPORTING TO 2 DIFFERENT ACCESS TABLES

[Developerme]

I want assistance with how to import information from a 1 excel file or 1
text deliminated report but portions of the file or report need to be
seperated and imported into 2 different access 2007 tables. Anyone have some
thoughts on how to do this? Thank you.

 

[Pete D.]

I find it easist to bring the files into access (import) and then use
create/update/append query(s) to sort the file out as needed into the
correct tables.

 

[Developerme]

Now that is an idea. Regarding the table. How would I run a update/append
query from a table?

 

[John W. Vinson]

Now that is an idea. Regarding the table. How would I run a update/append
query from a table?

Create a new Query based on the table (or on the linked spreadsheet or file,
using File... Get External Data... Link). Use the Query menu option to change
the query to an Append query. (An Update query will be useful if you want to
change the values of fields in records which already exist in your database,
which does not appear to be the situation).