Database linked to excel issue when refreshing

[thewiseguy]

Hi all,

I have a DB linked to an excel file. When I click "refresh" any field in access which are a validation list, the ID column is what is populating in excel, not the named field that I originally linked.

Any ideas as to why?

ps - I'm new to access.

thanks in advance.

 

[Micron]

cross posted

Excel connection to Access not returning correct data (ID rather than lookup value)

Hi all, Complete newbie with access and trying to simply keep a database of all of our products to be sold and updating our master excel worksheet/proposal generator as needed. I have a table with a few fields with lookup values as the data type. When I connect to excel and refresh the...

www.accessforums.net