I've a requirement where I need to call the HANA stored procedure from within Excel Macro. This is pretty much feasible with the SQL server by using the EXEC sytatement. I can connect to the HANA system and do 'Insert/Update/display' records in the Excel by writing the code in the Macro directly. After that I wrote the same SQL to display the table record in a stored procedure. I'm trying to call the stored procedure by using Call or EXEC statement but it doesn't work ?
After that I tried to use the Microsoft Query to connect but I'm getting error 'Data Truncated' after I enter the system details and the credentials for the HANA system.
Can anyone please let me know how can I call the HANA stored Procedure from the Excel ?
Thanks for the help