Export Combobox Values into Excel

Ed Nisan 31 Reputation points
2022-10-10T14:26:16.157+00:00

Hello Everyone,
I created a database with tables that have the options to a form / another table, when I import it into Excel using Data tab, the options come in as numbers (ID Field) instead of the actual values. what do I need to change in properties / settings to import the actual values instead?

Thank you for your help.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
830 questions
{count} votes

Accepted answer
  1. xps350 376 Reputation points
    2022-10-10T20:44:46.813+00:00

    Make this query:
    SELECT RESTbl.RESTbl AS [Caused by], RESCrw.RESCrw AS Crew, RESAct.RESAct AS Act, MainEnt.[Part Nmber], PTName.[Part Name], PTDefects.PTDefect AS Defects, MainEnt.[Scrap Date], MainEnt.Qty
    FROM PTDefects INNER JOIN (PTName INNER JOIN (RESAct INNER JOIN (RESCrw INNER JOIN (RESTbl INNER JOIN MainEnt ON RESTbl.ID = MainEnt.[Caused by]) ON RESCrw.ID = MainEnt.Crew) ON RESAct.ID = MainEnt.Act) ON PTName.ID = MainEnt.[Part Name]) ON PTDefects.ID = MainEnt.Defect;

    Import the query into Excel.


6 additional answers

Sort by: Most helpful
  1. xps350 376 Reputation points
    2022-10-10T17:26:22.427+00:00

    What you use here is a so called look up table. In your main table you store an ID (foreign key to the look up table). What you call the "actual values" are stored in the look up table. If you create a look up field in your main table Acces will STORE an ID but SHOW the actual value. Excel only sees and imports the stored value (ID).

    The solution is to create a query in Access joining both your main table as the look up table. Show the actual value in the query. Import the query into Excel.


  2. xps350 376 Reputation points
    2022-10-10T17:51:13.92+00:00

    The principle remains the same. Instead of a qeury with two tables, create one with six tables (main table and 5 look up table).


  3. xps350 376 Reputation points
    2022-10-10T18:57:11.947+00:00

    Can you share an example of your database? For example via (a link to) OneDrive or Googledrive?

    0 comments No comments

  4. Ed Nisan 31 Reputation points
    2022-10-10T19:12:26.67+00:00
    0 comments No comments