I have created 3 web link in TABLE to link 3 EXCEL files! Then in QUERY, I have create a query with the following SQL language.....
Select * from TEMP1 union all select * from TEMP2 union all select * from TEMP3
And the query do exactly what I wanted .....which is the combined result of all 3 EXCEL files showing under ACCESS query result VIEW.
However, I would like to have this result to be saved either in an ACCESS table or in an EXCEL file. How can I do that?? Any idea?? Thanks a lot!!
Select * from TEMP1 union all select * from TEMP2 union all select * from TEMP3
And the query do exactly what I wanted .....which is the combined result of all 3 EXCEL files showing under ACCESS query result VIEW.
However, I would like to have this result to be saved either in an ACCESS table or in an EXCEL file. How can I do that?? Any idea?? Thanks a lot!!