No replies to this topic

[postman]

Hello all!

I am in desperate need of advice for creating an application (API), or even an application package, that can:

1) Write Excel files
2) Dump information from Excel into an SAP database
3) Execute SAP functionalities such as running reports, transactions, etc
4) Exporting data out of SAP into Excel / CSV documents
5) Possibly move data between Microsoft Access and Excel

So the basic software I need to manipulate is:
1) Excel
2) SAP
3) Access


My main request: How should I go about creating an application that will perform these operations?

For Excel, I have looked into a Java library called "JXL" -- JExcelApi
It's by no means the ultimate solution but it can automate 90% of what I need done in Excel.

The other solution I have heard about is using Visual Studio and C#. This has been recommended as an ultimate solution since it's specifically designed to cated to Microsoft applications. My issue is that:

1) I have been told you need a version of Access and Excel installed on the computer to run the code
2) You need NET Framework 2.0 on the computer

Would I be able to create a stand alone, executable application that doesn't need NET 2.0 and Excel app to run using C# (and Excel 12.0 Object Library)?


For SAP, I have read that ABAP is written directly inside the SAP database instead of existing as stand alone files. How could I get an external application to communicate with SAP database to execute ABAP written commands? I have read that Java can be used to fulfill this role.

I understand my begginer / newb nature but I am very determined to learn and tackle this project head on.

Thank you for your time!