create a new Access file using an existing file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We keep a yearly list of students and schools. I use 3 tables: one for the
schools, one for school reps and one for the students, related through a
"codes" table. Each year we need a new DB for the new students, but the
school and school reps information generally stays the same. Without
starting from scratch to create a new file, how can I use the existing DB
file to create a new file for the next year's student list? I use Access
2003.
 
We keep a yearly list of students and schools. I use 3 tables: one for the
schools, one for school reps and one for the students, related through a
"codes" table. Each year we need a new DB for the new students, but the
school and school reps information generally stays the same. Without
starting from scratch to create a new file, how can I use the existing DB
file to create a new file for the next year's student list? I use Access
2003.
Click to expand...

Ummm... Why a new database for every year?

A school year value IS DATA. A student is a student, whether she's in
the class of 2004 or the class of 2009. Unless you're talking about
millions of students, I see NO point in creating a new database every
year! You can use Queries to select data for any particular year.

That said... you can create a new, empty database, and use File... Get
External Data... Import. The import dialog gives you a choice of
importing with data, or importing the design only.

John W. Vinson[MVP]
 
Back
Top