Import to a one to many database (1 Viewer)

Dear All

I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products)

My client needs to routinely send me lists of tests and the products that are in each test. I then need to put this information in to my database

I don't want to type out the information they send me, instead I want to devise a simple form for them to complete and email to me (perhaps in excel) that they populate, and I then import/paste in to my database

How should the excel form be structured so that it is both easy for my client to populate and easy for me to import/paste in to my database. e.g. importing lots of test and product information, rather than type it in. Bearing in mind the 1:M structure

Many thanks in advance for any ideas

Kind regards

Alex

I think you might be able to do it with a persistent recordset,

http://books.google.co.uk/books?id=UyjxRJ5QDWAC&pg=PA120&lpg=PA120&dq=%22persistent+recordset%22&source=bl&ots=mK993sp56Q&sig=oRsnSA2gNP-EnbWJmbGcgABTTgo&hl=en&sa=X&ei=O4AnU7GGOoit7QbJn4GAAg&ved=0CIMBEOgBMAg#v=onepage&q=%22persistent%20recordset%22&f=false

A belated thank you for your reply

No Problem...

Did you get persistent recordsets working or did you go for Excel?