I have just now seen your query, it's very much same what I would like to learn.
If you have already got the solution, please send me the guideline (sample VB
code, preferably VBA(Excel)-equivalent code if possible) on my email address firstname.lastname@example.org
My query is as follows:
I urgently need help in automating data download from As400 and upload in my Excel-VBA-based Application.
On my PC I have the IBM Client Access which I use to logon to BPCS v.6.4.2
I know the library & Files/Tables names and field names.
Can you please provide me with a sample VBA with SQL (and Reference & connection setup syntaxes) so that I know the basic steps which are required to achieve the objective of connectivity and retrieval of data.