Simple Question - Link Excel Cell to Access field

[dobber]

I have an Access table containing one record and one
field named "color". The data in this field (green, blue, etc.) changes with input from an Access form.

I also have an Excel spreadsheet where I want the "color" data from the table to be linked, so that when the "color" in the Access table is changed, so is the data in the Excel spreadsheet (when the Excel spreadsheet is opened the NEW "color" appears).

I've tried COPY (copying the text from the field in the Access table) and PASTE SPECIAL (while in cell A1 in Excel), but the LINK option isn't available.

 

[DougP]

in Excel 2000
there is a "Data" Menu option (if you installed ALL) at the installation. Or you can put in the Installation CD when it asks.
Get "External data" source
then you can specify an Access database and a so on...

I'm not sure if that exactly what you need but take a look at it.
I did try a test and it does bring over the data from Access and allows you to choose whether you want to update Excel when data changes in Access.


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive