Oct 12 2018 10:01 AM - edited Oct 15 2018 11:11 AM
I feel like I'm missing something really obvious but I'm not sure where I went wrong.
I'm trying to import a query from access to excel so that the query is always linked to the access database. I've done this for simple queries but this one has more columns that my old one plus a column using expression build. I don't know if this is relevant but it's the only difference I can think of. When I try to import the query, field names will transfer just fine but all the records will be missing. Original tables from access can be imported just fine. Below are previews from when I attempt to make the link. The first one with a query and the second with a table.
Edit to include steps.. Data tab => New Query => From Database => From Microsoft Access Database.
Anyone have any idea on why this is happening? I'd like to have the records show up for this query.
Oct 13 2018 10:01 AM
Hi Rachel,
I guess that's since you try to import from Access query, not from Access table as in first case.
Oct 15 2018 10:29 AM
Could you explain this a little more? I've always done Data => New Query => From Database => From Microsoft Access Database.
Is there another pathway that I can use for queries to show up?
Oct 15 2018 10:42 AM
Hi Rachel,
I didn't work with Access for a long while. Path to connect is correct, I only see from your screenshots what in one case you'd try to connect the query qryFruitBackground, in other case you connected the table tblSampleInfo
Oct 15 2018 11:10 AM
Ok. Yeah that's from the same navigation window. Thank you for replying though.