SAP HANA – Update HANA table from flat file

This blog post will help maintaining the data in custom table using flat file upload. The excel file will be maintained with data like Employee ID, Employee Name, Timestamp, Joining Date & Joining Time.

The Date and Time always demands for a specific format and if not maintained in proper format the data upload fails.  Please find the steps for data load from Excel file in SAP HANA Table.

Import Data from Excel file to HANA table

• Open HANA Studio
• Use the menu option: File –> import

• Import options will be displayed in the pop up screen. Select Data from local file under SAP HANA Content.

Select the target system in the next screen.

• Provide the file path, header row exists or not, import all data or the limit and the target table in the below screen shot and click on next.

• Map the file data to table fields and click on finish.

• The import is successfully completed

• The import is successfully completed

• The entries maintained in the excel file is as below.

It is necessary to maintain the correct format of timestamp, date and time fields for successful data loads. This technique is useful for loading data from flat file to HANA tables directly.