load data from excel to a table in hanacloud

[Eisson]

hello community I hope you are well,

I have a question about whether it is possible to load data from an excel connection to HanaCloud.

Why does the question arise? since there is a way to visualize the data through different types of connections, for example by ODBC we can visualize the views created in the HanaCloud database in Excel

Best Regards.

[amontella96]

hi eisson1992

i see nobody picked this up so i'm thinking your question not fully clear, are you asking about load data from hanacloud to excel or write data from excel to hanacloud .

thanks!A

[Eisson]

Hi amo,

the question is how to upload data from excel to hanacloud.

Thanks

[dvankempen · Accepted solution]

Hi Eisson,

You can load data from Excel into SAP HANA and SAP HANA Cloud. You would use an ODBC connection for this.

As documented

• Connect to SAP HANA Cloud via ODBC | SAP HANA Cloud Getting Started Guide

There is also a tutorial that goes through the procedure step-by-step. Note that this applies to both the platform on-premises as the cloud: same technology.

• https://developers.sap.com/mission.hana-cloud-clients.html

[Eisson · Accepted solution]

Hi Thanks for your reply, the connection part is useful to me.

But the part of loading data I do not think I have made myself understood yet, is for example in an excel sheet I have the columns and rows, the columns are equal to a table of the HanaCloud Database and by means of a button with logic to be able to load the new data to the database example the image, that when I click on the CARGAR button I upload that data

Thanks.

[dvankempen · Accepted solution]

You are looking for an Excel macro which loads data into SAP HANA Cloud?

This is not provided by SAP.

Here is an implementation example for SQL Server, which you might be able to adapt

• https://medium.com/geekculture/how-to-extract-data-from-sql-server-database-and-display-it-with-micr...

In the past, others have questioned about this on the community; you might find other sample when searching a bit more

• https://answers.sap.com/questions/11345981/connecting-hana-with-excel-through-vba.html

[Eisson · Accepted solution]

Hi,

Tthank you very much for your answer, if I will try to adapt it

Regards