Use Excel Info in Reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have set up an access databse that links to several different excel
spreadsheets that contain information on each property site such as
vegetation condition, forest health etc. Is there any way that when creating
a report in access, that certain information from the excel spreadsheet could
be pulled out and displayed in the report? I don't want all of the
information displayed in the report, only a few lines from the spreadsheet.
Is this possible?

Thanks.
 
Your Excel spreadsheets should appear as the "Linked Tables" in your Access
database. You can then use these linked Tables like other Tables, e.g. if
you want only "a few lines", use an Access Query to select the lines / rows
you want.
 
Back
Top