Re-populate Access database

[Dave]

This should be easy, but I can't figure it out. I'd like a copy of my
sample data stored somewhere, preferably another Access database, so that
when I modify my database structure I can re-populate it with sample data --
at least all that still fits with the new schema.

The closest I've come is very cumbersome: Export each table to Excel, then
import into each table from Excel.

Is there an easier way?

Dave

 

[Immanuel Sibero]

Hi Dave,

Let's say we call the one you're working with now the working copy. Make a
copy of it and call the new file the sample copy. Now you have two identical
copies. In your working copy, link to all the tables in your sample copy.
You can now proceed with your work on your working copy, make changes, etc.
You will then be able to repopulate your tables from the sample copy using
Append Query.


HTH
Immanuel Sibero

 

[Dave]

Beautiful...

Thanks!