Access UNION query

Question

Hello all,

I have several excel files that I have linked in an access db (not imported). There I call a UNION query and brings all fields (all excel files are the same- only data changes) into one big table in access. So far so good.

I would like though to have an identifier based on the excel imported. So, if I have excel1, excel2 etc I want to add also automatically in my access table a new field called for instance "excel source" and having there marked from which excel file the data is coming from.

Is that possible ? Any help appreciated!

Answer 1

Hi. You can add a calculated column in your UNION query. For example:

SELECT "Excel1" As FileName, Field1 FROM Excel1
UNION SELECT "Excel2", Field1 FROM Excel2

etc...

Hope it helps...

Answer 2

Hi KKaras,

I think the suggestion given by the DB guy can solve your issue.

please check the suggestion given by him and let us know whether it worked for you or not.

if you find that the suggestion given by the DB guy solves your issue then please mark the suggestion given by him as an Answer.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.