imported data shows as numeric KEY rather than text NAME

  • Thread starter Thread starter steve c
  • Start date Start date
S

steve c

I am exporting the results of a select query to excel.
When i run the query, the results appear as I want them
to, for instance, "Passenger Name" shows "John Doe."
However, when i select the query and run a File - Export
to excel, the information in certain fields is
represented by what appears to be a primary key rather
than the field with the actual text information I want to
look at. Does anyone know what is causing this to happen
or how I can fix it?
 
Hi Steve,

This sounds like one of the many gotchas of Access's misbegotten "lookup
fields". See http://www.mvps.org/access/lookupfields.htm for other
reasons why these sooner or later cause more problems than they solve.

Modify your query so it explicitly joins the related tables and it shoul
export OK.
 
Back
Top