You can open an excel workbook using an Access Application using an ADO/DBO
Open statement. You'll be addressing the excel data like a table in Access
by going to the correct row and then getting the correct Column in the table.

The Microsoft office Structure of an Excel worksheet and an Access tabgle
are really the same. There is only some problems in Access with diffeerent
versions of Access.

"Dan" wrote:

Hi,
All my data is in Excel, but can I display it using an access report that I
create via vba in Excel?
Many thanks,
Dan