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 upload data from excel to SAP,it would be
great.Any reply in this regard will be highly appreciated.