Hi all,

I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this tool, it works. But, my project requirements state that there might be multiple files to be processed together. I tried to cat multiple xls files into a single xls file on unix and tried to read it using the tool, but it does not work; probably because unix does not recognize this format. So, my problem is, I am not able to merge multiple excel files into a single readable file on unix.

I have a feeling this cannot be done. But I wanted the experienced folks on this forum to confirm the same. I would greatly appreciate any assistance I can receive on this. If any part of my question is not clear, please let me know and I ll explain.

Thanks!