How Do I merge Mult. Files

[sweffer]

Hey everyone,

I work on a project where I have some undergraduat researchers. I created a series of forms and tables, and gave them each copies, and they entered data into it. Now I have multiple files,from each student. For example one student might have been working on February-april 1976, so they named their file feb-march1976, another worked on April-June, etc. But the all have the same underlying form and table structure, so I want to now merge them, to have one "data set" with all fo the work that they've done. How do I go about doing that

Thanks in advance

Simon

 

[Graham R Seach]

sweffer,

I would link the tables from each database, then use queries to import the
data into your tables. Unfortunately, the primary keys will be out, so you
might have to do some fiddling if each database contains multiple related
tables.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

Hey everyone,

I work on a project where I have some undergraduat researchers. I created

a series of forms and tables, and gave them each copies, and they entered
data into it. Now I have multiple files,from each student. For example one
student might have been working on February-april 1976, so they named their
file feb-march1976, another worked on April-June, etc. But the all have the
same underlying form and table structure, so I want to now merge them, to
have one "data set" with all fo the work that they've done. How do I go
about doing that?