MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Sap Connectivity Codes

  Asked By: Zobah    Date: Feb 02    Category: MS Office    Views: 1007

I am working in a MNC company. I am developing a module to gave a
formatted output which the data imported from SAP. Instead of that, is
it possible to connect SAP via excel macro? If possible pls help me by
giving some sample codes for connecting SAP & entering data in SAP
through excel macros.

How i can automate for entering data in Sap? Pls help with some
sample codes.



2 Answers Found

Answer #1    Answered By: Dale Jones     Answered On: Feb 02

I suspect that this is a question better asked of SAP support people.

Answer #2    Answered By: Nicolas Costa     Answered On: Feb 02

I would suggest you need to learn about how to connect  to SAP databases via

One thing you’ll need is the proper “Connection String” for SAP for your
particular environment. You may also need to learn about ADO if you haven’t
experienced it already.

Google searches with combinations of terms like SAP, Connection String, ADO,
OLEDB and ODBC should yield the results you’re looking for.

Once you get the proper Connection String, then you’re basically dealing
with straight ADO issues, of which there is a lot of documentation

Didn't find what you were looking for? Find more on Sap Connectivity Codes Or get search suggestion and latest updates.