Export Data

[hithere]

I am trying to export data from my database into an excel file. The problem I am having is that fields represented in access with an autoid are showing up in the excel as the autoid and not the corresponding name associated with the autoid. Is there any way to get around this?

[June7]

You mean the autoid that has been saved as a foreign key in another table? You are exporting from that second table? Export records from query that joins the two tables. That will make all fields from the related tables available.

[hithere]

I'm exporting from the query that joins the two tables and they are joined by a relationship. I get the actual names when I run the query by the autoid when I export the data.

[June7]

What method are you using for the export?

If you include the name field from the associated table in the query, it should export. Show the query SQL statement for analysis.

[hithere]

Below is the query I have made

SELECT qry_Info_Pt.MRN, qry_Info_Pt.LastName, qry_Info_Pt.FirstName, tbl_Referral.DischargeHosp, tbl_Referral.AdmitFacility, tbl_Referral.Date, tbl_Referral.Insurance, tbl_Referral.Comments, qry_Info_Pt.Name, tbl_Referral.ReferralID
FROM tbl_Info_Fcy INNER JOIN (qry_Info_Pt INNER JOIN tbl_Referral ON qry_Info_Pt.MRN = tbl_Referral.MRN) ON tbl_Info_Fcy.ID = tbl_Referral.DischargeHosp

To export the data I am right clicking on the query name

[June7]

So it exports ID instead of Name? Does it export the LastName and FirstName values? Why do you need Name also?

[hithere]

It exports the autoID associated with each facility name and not the facility name itself. When I run the query in access I can see the names perfectly fine but when I export the data the autoID is what is visible.

[June7]

Probably because of a lookup. Include the Facilities table in the query and pull the actual FacilityName field into the query.

[hithere]

Thank you so much!! Worked perfectly!