imported data shows as numeric KEY rather than text NAME

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?
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imported data as numeric key? 2
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Select text of a particular shading color (VBA macro) 5
Query Key 3
QBF & Query Malfunction 0
Page numbering with Merged Document and IF statements 1
Mailmerge displays primary key rather than text 1
query to show where no data in a stated column 0

Top