a system error during import data from local file into table

[Former Member]

Hello Every One

     Today I find a strange promlem about import data from local file into table  ,if my table hava a column defined by 'date'. when I want to import data form local file into table. It always  output a strange error. Is anybody also met this situation？

     this is my table:

    

    this is my local file:

           

    this is the error message:

           

Besr Regards,

  Tang

[former_member182779 · Accepted solution]

The right format for dates is:

YYYY-MM-DD

So in your .csv file you should use 2011-03-06

Greetings,

Blag.

[Former Member]

Hi Tang,

The problem is due to being unable to convert the excel value to the date format in HANA. You can either change the type of FLDATE to varchar, or you can convert your excel to a csv format and enclose your dates in quotations in the following format.

You should be able to upload the data to your table this way.

Thanks,

Sharan