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

[thewiseguy311]

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 connection, excel shows the ID value associated with the record, NOT the actual lookup value.

Any ideas on what I am doing incorrectly?

Any help is greatly appreciated!


/mike

[Micron]

Cross posted https://www.mrexcel.com/board/thread...shing.1175016/

You should declare wherever you cross post that you did so, even if you got no answers. Maybe read Cross Posting Message

Maybe your issue is that you're using lookup fields in Access tables - don't. The value you see is actually stored somewhere else and is not viewable in tables. The real value in the record is an ID number. You might get away with using .Value in your query field name; e.g. Orders.Value Memory fuzzy on that because I don't use them.
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/m...lds/4594468763

[thewiseguy311]

my apologies. didn't realize i had to notify of a cross post between 2 sites. thanks for the recs.

Cross posted https://www.mrexcel.com/board/thread...shing.1175016/

You should declare wherever you cross post that you did so, even if you got no answers. Maybe read Cross Posting Message

Maybe your issue is that you're using lookup fields in Access tables - don't. The value you see is actually stored somewhere else and is not viewable in tables. The real value in the record is an ID number. You might get away with using .Value in your query field name; e.g. Orders.Value Memory fuzzy on that because I don't use them.
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/m...lds/4594468763

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.