One Star

Read large excel 2007 file

In my project i must load a large excel 2007 file into Oracle DB .. the file is 118 MB with 255000 rows
My component TfileInputExcel can't read and generate an error Java heap space out of memory ... i've set the java parameter Xms2048M and Xmx4096M
There is a way to do that?
Talend Open Studio 4.1.1
Thank in advance
Regards
marco
1 REPLY
Community Manager

Re: Read large excel 2007 file

Hi
Do you still have other components such tFilterRow, tMap in the job? Where do you set the JVM parameters?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business