How to call specific excel cell contents from access?

[nardvark]

Hello:
I wish to call the specific contents of an excel workbook, and have them display in the table or form (doesn't really matter which, though it'd be nice to have it in the table) of my access database. I've been able to use hyperlinks or OLE objects to have it open excel and point me to the location of the number, but what I really need is for it to fill the number in the table or form so that I can treat it like data. It's not an issue of resources, excel could be open for all I care, it's just that there's no convinient to compare the data when you have to open each workbook one at a time and write the numbers down somewhere else...
The reason I want to link to these workbooks is that each one contains 6 columns of data, two of which depend on the other four and are used to do a linear least squares regression and produce statistics (slope, intercept, error estimates, etc...). The slope, intercept, and other data is what I wish to have displayed in my database.
Thanks in advance!

 

[gwinn7]

Why not just link the spreadsheet as you would a linked Access table? Then, use that linked Excel "table" as a RecordSource for your form?

Gary
gwinn7
A+, Network+

 

[nardvark]

I don't want a whole spreadsheet, I just need one value from each spreadsheet to go into one record. so I've got a "slope" column in my database, and each record will call a different spreadsheet and extract that single value and place it in the column.
I didn't think linking would let me do this, am I missing something obvious?
Thanks for the reply!