Is it possible to import only relations data to to database.

[Sirritys]

Hi,

I have now tried near every way I could imagine to import tables over
existing ones when database has plenty of relations. Access just seems
not to be able to do this due to relations. (I have database which is
supposed to be updated once a week from txt-files from another system)

So is there a way I could import files to other database and after that
import only relations data from existing database? This way I could
start using the newly created database without drawing relations again.

Another thing that came to my mind: Could I somehow create a database
with tables which would actually be only references to another
database? This way I could create relations to this database and data
would be stored in another one (and this way I suppose I could update
data).


I hope someone could find a solution for this.

I'm starting to be desperate

Regards,
Sirritys

 

[Arvin Meyer [MVP]]

You don't need to import the relations to import the data. If the data that
you are importing from is in normality and the data that you are importing
to is in normality, then you import the one side first, keeping the original
key as a link. Then import the many side, creating new links if necessary.