Excel cell data

[gguy]

I receive data in 10 separate excel spreads on 10 different balances. In the spreadsheets there are 100s of calcs that go into the standard deviation.
I need the standard deviation(sd) from each of these spreadsheets in a balance table. Currently, we manually input the sd for each balance.
I would like to run a query whenever the database is opened to poll the 10 spreadsheets and pull the specific cell info for the SD.
I don't need help with the link.
I need help pulling the specific cell data from each spreadsheet and making sure that the SD pulled goes to the correct balance.
I am thinking that I might need two queries to get this done.

Thanks, GGuy

 

[gguy]

How do I move link data to a table

I really need some help with pulling or querying linked specific cell data to a Access table. Is there a way to pull the value in, say, cell W23 of a linked Excel spreadsheet to a table? Thanks, GGuy

 

[KKilfoil]

It would simplify your problem to do a bit of massaging in Excel first.

Create an 11th workbook to bring the 10 SD values via links into one 'table', with a column that suitably identifies which SD it is, and one for the actual value of the SD.

Give this a range name in Excel, such as 'AllSDs' or whatever. You should be able to create a linked reference to this range in Access (use the Link Table wizard, select Excel Type) to walk you through this.

This table can now be used in Access as if it were local.

BTW, I suspect this thread would have been better on the General or Excel forums (fora?)