I need to create automation for uploading Excel data onto SAP R/3 using VBA.Have never done this before.Hence a few questions.
1.Once SAP is installed what references do i need to put in the VB Editor under Tools->references in order to connect to SAP and use its objects?
2.Can i achieve uploading of data from Excel using ODCBC.
3.I searched the net for excel to SAP links and found a term called RFC functions.What is RFC.
4.Do we need ABAP coding as well to achieve the same?
If someone can help me with the code for uploading data from excel to SAP,it would be great.Any reply in this regard will be highly appreciated.