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 to cell A1, so that when the "color" in the Access table is changed, the data in cell A1 within the Excel spreadsheet is also changed (when the Excel spreadsheet is opened the NEW "color" appears). I do not desire to change the data within the Access table via any input within the Excel spreadsheet.
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.
Any ideas?
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 to cell A1, so that when the "color" in the Access table is changed, the data in cell A1 within the Excel spreadsheet is also changed (when the Excel spreadsheet is opened the NEW "color" appears). I do not desire to change the data within the Access table via any input within the Excel spreadsheet.
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.
Any ideas?