importing multiple records in a subform

[S Willingham]

I have a database that tracks the sent emails to my contacts

I have multiple tables

tblContacts
Company
Firstname
LastName
Etc

tblCustomerEmail
CustomerEmailID
EmailID
CustomerID

tblEmailInformation
EmailID
EmailName
Etc

All my tables are linked correctly and my forms are build. everything works
with the test data I have entered so far.

I have been tracking this with excel up to this point. Is there a way I can
import my current records from excel and have it populate the subform where
the email information is stored.

Looking for a way to automate this to save time.

Thanks in advance for your help

Steve

 

[Douglas J. Steele]

Forms and subforms don't have data: tables do.

Use the TransferSpreadsheet method to import the data from Excel into the
appropriate table so that it will show up on your subform.

 

[S Willingham]

Thanks Doug,

I am not familiar with the TransferSpreadsheet method. I tried to do a
little research but I am still lost.

One challenge I have is that I have linked tables and I am trying to
populate from a single excel DB. Is this possible using the
TransferSpreadsheet method?

Thanks for the help

 

[Douglas J. Steele]

You could use the TransferSpreadsheet method to link to Excel, rather than
import it. You'd then be able to write queries against that linked table to
populate your other tables.