Online Tutorials & Training Materials | STechies.com
Register Login

HANA Studio not responding when uploading large MS Excel files

25 Feb 2016 1:38 pm || 0

Whenever we are uploading a large MS Excel files using the option File -> Import -> SAP HANA Content -> Data From Local File, SAP HANA Studio goes into not responding mode.

To resove this issue please do as follow:

As a workaround, convert the large XLS/XLSX files into CSV format, to load them into HANA tables. There are no size limitations for CSV files.

Convert the XLS/XLSX files to CSV files using the Option in MS Excel.

File   > Save As   > Save as Type   > CSV(MS-DOS)

Read more about Steps to Download and Install SAP HANA Studio