Jimbo's VBA Automation Suite
What you are getting
Sprinkled throughout this site are great VBA scripts to use with MS Access in conjunction with SAP. Many of these are simple functions to remove duplicates from tables or to export directly from Access to text. Some of the functions even export to complex Excel spreadsheets. Most recently added was support to export directly from MS Access to Unicode text files.
Where did it come from?
For years I made additions, updates and tweaks to this suite of tools specifically for use when transforming data to be migrated into SAP. These tools can be used for that any many other things, but as my ABAP skills improved, I began to perform more and more transformations in LSMW.
In 2007, Microsoft Excel began handling more than a million rows and that works for most SAP implementations when the transformation and validation is occurring in LSMW. Occasionally, I break open Jimbo's VBA Toolbox to handle tasks that exceed Excel's limitations or take too long.
That Microsoft failed to solve the 2GB size limitation on Access databases doesn't help, either. Having frequent backups can mean the difference between go-live and no go-live.
Troubleshooting and Known Issues
This product is provided absolutely free of charge and, as such, includes no warranty or support. This product is intended for the use of programmers and tips for troubleshooting and resolving known issues are provided on the Jimbo's VBA Automation Toolbox information page.
Jimbo.mdbRevision History
- 1.3: 18 June 2019--added the
SAP_RFC_READ_TABLEfunction for extracting tables from an SAP system using RFC.
