BreadCrumbs: Excel Mulit File Query

Excel Mulit File Query

From Luke Jackson

(Difference between revisions)
Jump to: navigation, search
Revision as of 02:43, 5 October 2008 (edit)
Ljackson (Talk | contribs)

← Previous diff		 Current revision (02:46, 5 October 2008) (edit)
Ljackson (Talk | contribs)

 
Line 40: Line 40:
[[Category:Windows XP]] [[Category:Windows XP]]
-[[Category:Excel]] 

Current revision

[edit]

Merging Multiple Excel Files Together

Joining Excel documents can be quite useful for reporting. All of the files you want to merge will have to have the same column names.

Image:multi_excel_step_1.jpg

Image:multi_excel_step_2.jpg

Image:multi_excel_step_3.jpg

Image:multi_excel_step_4.jpg

Image:multi_excel_step_5.jpg

Image:multi_excel_step_6.jpg

Image:multi_excel_step_7.jpg

Image:multi_excel_step_8.jpg

Image:multi_excel_step_9.jpg

Image:multi_excel_step_10.jpg

Using UNION ALL we can join as many files as we need. 

SELECT * FROM `L:\Quality Control\Redo Sheets\redo_sheet_lri.xls`.`'Redo Sheet$'`
UNION ALL
SELECT * FROM `L:\Quality Control\Redo Sheets\redo_sheet_jra.xls`.`'Redo Sheet$'`

Image:multi_excel_step_11.jpg

Image:multi_excel_step_12.jpg

[edit]

Tags

Joining Excel Documents, Various Documents, Many Excel Files

Retrieved from "http://wiki.ljackson.us/Excel_Mulit_File_Query"
Personal tools