Importing filtered data from excel.

[JOSE LUIS]

Hello everybody!
I need to import some data from and excel worksheet (VisaID, TestDate and Mark) to a access table, tblTest (TestID, ContactID and Mark). The problem is that I only have to import the data from my contacts, not the rest, and I´d like to do it programatically so that I can save a lot of time, however I don't know neither how to start nor the best way to do it, maybe these are the steps i need to follow:



1º Because tblContacts contains : ContactID and VisaID, could I export the contactID to the contacts who VisaID in the worksheet match with the VisaID of the tblContacts?

2º Could I filter then the worksheet, importing only the records with a not null ContactID to my TestTable (VisaID, TestDate and Mark)?

I'll be very gratefull of any help.
Thank you very much in advance.

[June7]

Depending on the Excel data structure, can probably set a link to the sheet. Linked sheets can be used just like tables in queries. The linked sheet can be used as data source for INSERT and UPDATE actions into other tables.