trying to create a new database using the format of 1 with the data from
another.
should i import the data into the database w/the format I want OR should I
create a new database and try to link and import the two?
please help
Since we have absolutely NO idea about the structure of either
database, what you mean by a "format", the nature of the data, or much
of anything else... it's a bit hard to advise.
If the structure of the *tables* is the same in both databases, you
can create a new database; use File... Get External Data... Import to
import everything from the model database, selecting the "Design Mode
ONly" option when you're importing tables. Then you could use File...
Get External Data... Link to link to the database containing the data
you want, and run Append queries to migrate the data into the (empty)
tables.
If you mean something else, please explain.
John W. Vinson[MVP]
