Import Tables Keeping Relationships 1

[btalon]

I'm using Access 97 and I have a macro I will execute with VBA that will import 3 tables. I want to keep the relationship between the tables during the import. I noticed that it isn't bring the relationships with it. However, if you manually goto File>Get External Data>Import, and import the table that way it does bring the relationships over. How can I accomplish this with a macro or VBA?

 

[HitechUser]

btalon,

This should do the trick... Microsoft

I hope this helps.

 

[btalon]

Thanks HitechUser, that's all I needed.