Skip to Content
0
Nov 14, 2017 at 01:42 PM

Import CSV file dynamically in a procedure SAP HANA

2039 Views Last edit Jun 06, 2018 at 02:32 PM 4 rev

Hi All,

I am trying to import some data from a CSV file into HANA table as below,

IMPORT FROM CSV FILE 'C:/Users/Desktop/zone1.csv'
INTO "SCM"."ZONE_TEMP" 
WITH RECORD DELIMITED BY '\n'
     FIELD DELIMITED BY ',';

Below error is being displayed when I execute the above code,

Could not execute 'IMPORT FROM CSV FILE 'C:/Users/Desktop/zone1.csv' INTO "SCM"."ZONE_TEMP" WITH RECORD ...' 
SAP DBTech JDBC: [2]: general error: Cannot open CSV file, C:/Users/Desktop/zone1.csv

Any suggestions would be appreciated.

Thanks,

Srinivasa Reddy