Use Excel Info in Reporting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Blair - 29 Jun 2005 23:08 GMT

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.

Reply to this Message

Van T. Dinh - 30 Jun 2005 02:24 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hi, I have set up an access databse that links to several different excel
> spreadsheets that contain information on each property site such as
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message