Skip to Content
0
Feb 23, 2017 at 03:47 AM

HANA Stored Procedure from Excel

847 Views

Hi Experts,

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

Alok