I want to convert existing flat database into a template that I down loaded
from this web site. but how do I change the field name to match my existing
database and how do i import the database into the new one
This may not be all that easy, though it can be done.
I'd recommend using File... Get External Data... Link to link to the
flat file; then create as many Append queries as you need to migrate
the data into the normalized tables. An Append query can easily append
data between fields of different names. Depending on the structure and
contents of your two databases this may require several queries, some
of them Distinct Value queries (where you are trying to extract
repeating records into a single record). You'll need to append the
"one" side table (or tables) first, followed by their related tables.
If you have trouble, please post back with the field names and types
in your table, and in the template into which you're trying to move
the data.
John W. Vinson[MVP]
