Import data from SAP Fi in MSAccess database

[Flippertje]

Hi all,

i have SAP Fi and want to import data to MS Access.
When i take a peek in the references to register an ocx or dll, i see a list of about 50 library's. I'm clueless on determening which to choose.

Has any of you ever tried this before?
- which ocx and or dll's did you use?
- what code did you use?

Many thanks!!!!

Flippertje

this post has also been posted in VBA for applications forum and VBA MS Access Modules.

 

[ermad]

If you are working with MS Access and connecting to SAP, take a look at the SAP ADO.NET Data Provider from RSSBus:

http://www.rssbus.com/ado/sap/.

Basically the data provider gives you ADO.NET Access to SAP tables - Easily call BAPIs and function modules with no WSDL, DTD, or other XML structure knowledge required.

-Eric