Importing Excel into Crystal (mulitple tabs)

[aj3221]

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?

 

[kray4660]

So, after looking up some info about how to create a command to pull from Excel. I created a simple Excel spreadsheet with two tabs and two columns (id and data). After dropping the first tab (Sheet1) into the report. I looked at the SQL query. Copied it. Removed the Sheet1 data from the report. Created a command and pasted the SQL query then did a union to connect my second tab. See example below.

SELECT `Sheet1_`.`id`, `Sheet1_`.`data`
FROM `Sheet1$` `Sheet1_`


union

SELECT `Sheet2_`.`id`, `Sheet2_`.`data`
FROM `Sheet2$` `Sheet2_`