Exporting from a Relational Database in Access to Excel 1

[rjsmetal]

I have a relational database and a user wants a copy of one of the tables in excel, the only problem is when I export it, the table only shows the primary keys that are linked (one to many) and not the value the user needs. Example User shows the User ID and Not the User Name, as the tables are joined on User ID. How can I get the export to show that User Name.

Table One:
Project ID
User ID
Date
etc...


Table Two:
User ID
User Name
etc...


Thanks for any help - metal

 

[PHV]

Export a query instead of the table.
Even better (in my opinion) pull the data from Excel with MSQuery.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

metal,

If it were me, I'd query from Excel to you database (using ms query) via Data/Get External Data/New Database Query -- whatever database like access files -- YOUR database -- the tables that you need to JOIN to get the username -- next, next, next, select the option to EDIT THE QUERY and finish.

This puts you in the MS Query Grid. Join the tables appropriately, drag the fields to the grid, add any criteria and then File/Return data to Excel.

VOLA!

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[swtrader]

Export from a query that has both tables.