Linking Access to Excel

[Beeyen]

Good Day,

I am using Import External Data -->Database Query in Excel to import a query
with data from Access into Excel. Everything works fine except some of the
fields show the autonumber from the table. For example, I have a table
called WorkType with one of the items listed as file. I run a report from
the query and the information shows as it should, returns a selection from a
form by a drop down under WorkType called file.

When I execute the Import External Data and finish, it shows the autonumber
in the cells as oppose to the list item from the table that was used in the
query.

Does anyone have any ideas about what may be occurring when importing the
query into Excel?

Thanks for any insight you may

 

[Jeff Boyce]

Not sure about the interaction with Excel, but there's a possibility that
the underlying table has that field defined as a "lookup" data type. This
causes confusion, as it stores the primary key value, but appears to hold
the "looked-up" value.

If you need to see the looked up value, consider building another query in
Access that joins the main table to the lookup table on that field, then use
the lookedup value from that (lookup) table. Also, consider changing the
datatype in your main table to Long Int.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.