How to Retrieve Data from Excel?

[Paul Vovk]

I would like to write a VBA function in Access to perform
operations in Excel in a specific file and return the
contents of a cell. Can I open up and manipulate an Excel
file from within Access? If not, can I at least extract
the value of a cell in a spreadsheet and return it to
Access?

 

[Guest]

You can "Automate" Excel from Access and make it do whatever you like. Here's an articel showing how to do it from a web page. You can cut the Javascript function and with just a few changes have it working in Access

remove curley braces
remove semi colon
convert var to Di
convert var oXL = new ActiveXObject("Excel.Application"); To Set oXL = CreateObject("Excel.Application"

That should do it for ya ..