To connect a sample to a location, you need to have a way to, well, connect
the sample to the location...

Does the .csv sample data include a locationID, or LocationName, or some
such?

Do you have a list of all possible Locations? ?with IDs?

Can you have more than one assay result per sample? How do you connect an
assay result to a sample ... do you have a SampleID (i.e., a unique
identifier for each sample)?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"alia" wrote in message
...
At work we are going to be setting up a MS Access database for some
geological data. We are going to be getting some other data in .csv format
that we would like to add to this database.

What we have is a collection of location ID's and corresponding sample
numbers. Not every location ID will have a sample taken from it. We will
be
getting assay results in from the lab on each sample taken, and I want to
link the assay sample results (the .csv files) to the appropriate sample
IDs
in the database.

How do I do this? Is it as easy as making a table for the .csv data and
linking that to a table in the DB? My Access knowledge is very rusty, so I
apologize in advance if this is the most basic question ever, or if
there's
not enough information - just ask and I will try to provide more.

thanks and cheers,
alia