cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to SAP HANA via Excel macro(Visual Basic) programs.

jungwoo_han
Advisor
Advisor
0 Kudos

My CT wants to know how to connect to SAP HANA via Excel macro(Visual Basic) programs.

If you would know about how to guide, please let me know with some example programs.

thanks in advance

regards

JW.

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Your client can use the ODBC connectivity to access SAP HANA from VBA.

For more convenience it might be worthwhile to look into .net for Windows platform development.

Please see the development documentation on that.

For general advise how to access databases from VBA you'll find plenty of resources on the web.

- Lars

Answers (1)

Answers (1)

jungwoo_han
Advisor
Advisor
0 Kudos

Thank you Lars

My CT and I just solved this issue due to your hint.