ETL and Data Integration tools - Modern ETL software for everyone

Hello

I'm having a problem joining two worksheets together from an Excel file
Each worksheet loads separately ok, but when I join them nothing is loaded.

select
"'Rates$'"."F1" as "Destination_Rates",
"'Rates$'"."F2" as "Price",
"'Rates$'"."F3" as "Effective_Date",
"'Numberplan$'"."F1" as "Destination_Numberplan",
"'Numberplan$'"."F2" as "Code"
from
"'Rates$'", "'Numberplan$'"
where
"'Rates$'"."F1" = "'Numberplan$'"."F1"


Regards,
George

George

Regarding the joins.
Perhaps excel returning different field types try cstr(fieldname). it converts field data to character.
This might help as well.

Excel is a real pain: one day it works another it does not..

Mike