Use data from access in a cell
 

I need to pull some data from Access into Excel, but it's more complicated
than getting the whole table.

I've got a spreadsheet, and I need one cell to pull a value from an access
db based on the value in another cell in the row: One of the columns in the
sheet contains a unique serial number, and the cell should contain the value
of another field from a record in the db which has the corresponding serial
number.

I'm guessing I should be able to do something like "SELECT assets.hostname
from assets where assets.serial = A2", but how?

I can't use the SQL.REQUEST function as I'm using Office 2007.

Use data from access in a cell
 

See Nick Hodges' site for an explanation of how to do this

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

"BMC" wrote:

I need to pull some data from Access into Excel, but it's more complicated
than getting the whole table.

I've got a spreadsheet, and I need one cell to pull a value from an access
db based on the value in another cell in the row: One of the columns in the
sheet contains a unique serial number, and the cell should contain the value
of another field from a record in the db which has the corresponding serial
number.

I'm guessing I should be able to do something like "SELECT assets.hostname
from assets where assets.serial = A2", but how?

I can't use the SQL.REQUEST function as I'm using Office 2007.