Import data to contact table and create record in related table

[Guest]

I have two tables. One contains contact data and the other contains status
information that is related to the contact data. I need to be able to import
data into the contact table and create a default record in the status table
linked back to the contact record. Any ideas?

 

[Carl Rapson]

I have two tables. One contains contact data and the other contains status
information that is related to the contact data. I need to be able to
import
data into the contact table and create a default record in the status
table
linked back to the contact record. Any ideas?

What's the source of the imported data? If it's linkable, what I'd do is
link to the data source instead of importing it. That way, you can refer to
the data source as just another table. Add a new code module to your
application and create your own sub or function to open a recordset based on
the data to import and insert each record into the contact table, creating a
default record in the status table along the way.

Carl Rapson

 

[Guest]

Thanks, I will give that a try. I think I can make that work.