Excel accessed from Access

[JerryS]

Can a file in Excel be read from within Access (say from a Form) or does it
have to be loaded in to an access table first before it can be used ?

 

[John Nurick]

Hi Jerry,

There are three ways of getting at data on an Excel worksheet:

1) importing to an Access table
2) linking (File|Get External Data|Link...(
3) with VBA code that uses Automation and the Excel object model to get
the values from individual cells.

Can a file in Excel be read from within Access (say from a Form) or does it
have to be loaded in to an access table first before it can be used ?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.