Skip to Content
avatar image
Former Member

HANA Stored Procedure from Excel

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 23, 2017 at 06:13 AM

    Please use the search here in the Community. The topic was already discussed in post Connecting HANA with Excel through VBA.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Florian Pfeffer

      Florian,

      As I mentioned in my question, I've written the simple select query to display the table data onto excel spreadsheet. It's working fine. Now

      I want to call exactly the same sql from with a stored procedure that I've created in HANA. Now instead of writing the Select * on the table, I'm calling my stored procedure using CALL/EXEC statement at the same place and storing the table data in the same variable that I was using before with my select query. To call the procedure I used this syntax, CALL "Schema_name"."Procedure_name" but I'm getting this below -

      System Error &H80040E14 (-2147217900).

      I tried with EXEC statement also but got same error.

      Thanks

      Alok

  • avatar image
    Former Member
    Feb 27, 2017 at 05:31 AM

    Hi,

    Does anyone know the syntax of calling HANA Stored Procedure from Excel ?

    Thanks

    Alok

    Add comment
    10|10000 characters needed characters exceeded