Importing data to use in Access

[Mimadocken]

I'm working with a volunteer organization. Much of the information they receive (and need to work with) arrives in Excel spreadsheets OR Adobe PDF formats. We are unable to control how this information arrives, but we need to USE SOME OF the information quickly along with data we currently store in Access 2007.

We will received LARGE spreadsheets, but only use about 100 rows of data. The rows change on a weekly basis. Is there any way to filter Excel spreadsheets quickly so ONLY those rows with data that is relevant to our purpose can be appended to Access tables? None of this has been started yet, and I'd like to do this intelligently.

The same is true for the PDF files. They may have a few thousand rows of data (only about 10 columns), and we need to extract the relevant 100 or so rows.

Thank you for any advice you can offer.

 

[Addyman]

Are the rows required (the 100 or so) already marked or highlighted in some way in the spreadsheets you receive or does someone have to identify them after you receive them?

 

[Mimadocken]

We have to identify the records we'll use. Thanks for asking.