Skip to Content
0

Importing date value from excel into HANA MDC table ?

Jan 06, 2017 at 08:16 AM

173

avatar image
Former Member

I am not able to import records of type date into table. I am not getting any error but there are no values being imported or shown when I execute select query on the table.

I am attaching few screen shots on how I am doing it, if there is any formatting error related to date format then please let me know which is the correct or right way to do it.

Table: _USR_DATE

Excel file: No headings, only Date values in YYYY-MM-DD format (language - UK using format cell option)

Note: Further I want to use time stamp data type in my table and import the same, what different do I need to do in this case.

h0.png (15.8 kB)
h1.png (2.8 kB)
h2.png (30.8 kB)
h3.png (19.5 kB)
h4.png (8.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers