Importing Excel into Crystal (mulitple tabs)
Importing Excel into Crystal (mulitple tabs)
(OP)
I use this function a lot but have always wondered if it's possible to import an excel file with 2 different tabs to make them into 1. I have some data (.xls) that has two tabs. It's continuous data so I would like to bring in the 2nd tab and merge it w/ the 1st tab (like you can do in sql) but whenever I try to bring the 2nd tab in, it creates it like a whole new file and wants to find the joins between the spreadsheets. Is there a way to do this that you know of?
RE: Importing Excel into Crystal (mulitple tabs)
SELECT `Sheet1_`.`id`, `Sheet1_`.`data`
FROM `Sheet1$` `Sheet1_`
union
SELECT `Sheet2_`.`id`, `Sheet2_`.`data`
FROM `Sheet2$` `Sheet2_`