Windows Vista 
Access 2007
I connected Access DB to Excel using the Microsoft query but after successfully querying few fields. I notice that the result generated in my field gave me the corresponding IDs related to that field rather than the names in the field. However, the result displays the Category name in Access Datasheet view but shows as ID in Excel. What do I need to do or how do I make the query return their names and not their IDs in Excel as it shows in Access datasheet view.
below is an example of one of the table in Access. So when I retrieve category name in Access, it lists Apple, Banana, Pineapple, Mango. But when imported via Microsoft query into Excel the same query displays the ID instead. Helpppppp - I need the same query to display as category name in Excel.
Category table
ID Category Name
11 Apple
22 Banana
33 Pineapple
44 Mango
Thanks Much!
Reply With Quote
Originally Posted by Shilabrow
