What if i have to copy data from three different workbook into three different sheet of one workbook.
Can you please suggest me how can i do that....as i have tried using three export and import component but it did not work and also for importing in one workbook, we have to take three different component of excel and providing the pat of same file as one component will not let you select all three different sheet.
I am unclear of what you mean by three components. If you are simply moving data around one workbook, then you should only have one Excel connector. You would use the ExportData method to export the range of data from one sheet and the ImportData to move it to the new sheet.