Hi, I'm fairly new to querys.
I have 11 identical workbooks named issuelog0 - 10
They all have a sheet with the named range "Archive".
All the datasources have been established and I can independantly create a query table for each.
What i would like to do is union merge all of these sources into one table only. However, there seems to be no reference in he SQL code to the datasource so i do not know how to go about this without running all the querys on different sheets and then usig a seperate workbook to merge those tables?
Can anyone help me out here, is this even possible in Excel?
This is the Query for one table
May thanks
I have 11 identical workbooks named issuelog0 - 10
They all have a sheet with the named range "Archive".
All the datasources have been established and I can independantly create a query table for each.
What i would like to do is union merge all of these sources into one table only. However, there seems to be no reference in he SQL code to the datasource so i do not know how to go about this without running all the querys on different sheets and then usig a seperate workbook to merge those tables?
Can anyone help me out here, is this even possible in Excel?
This is the Query for one table
Code:
SELECT Archive.`Job Number`, Archive.PostCode, Archive.Issue, Archive.`Sub Issue`, Archive.Comments, Archive.User, Archive.`Date/Time`, Archive.`Logged By`
FROM Archive ArchiveMay thanks
