Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to load CSV files into HANA

1.- Create an CSV file with your data

2.- Copy the file to dropbox/yourname inside the HANA box

3.- Create a table in HANA with the structure of your file

4.- create the control file BBB with the following information:

import data

into table XXX."YYY"

from 'ZZZ.csv'

record delimited by '\n'

fields delimited by ','

optionally enclosed by '"'

error log 'Text_Tables.err'

Where XXX is your schema, YYY is your HANA Table and ZZZ is your file

5.- Open an Script File and write the following:

LOAD FROM '/filer/dropbox/yourname/BBB.ctl';

where BBB is the name of your control file

Greetings,

Blag.

Not what you were looking for? View more on this topic or Ask a question