Excel accessed from Access

  • Thread starter Thread starter JerryS
  • Start date Start date
J

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 ?
 
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 ?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top