Access to Excel To Rumba ?!? as-400?!?

[HaroldIII]

Ill do my best to describe what I need to do...

Please keep in mind, I am a noob and the only macros i know how to run are very basic.

I have MS Access run some compares, then I output a few excel spreadsheets.

I then open these EXCEL spreadsheets and manually input all these fingures into the Rumba/AS-400 Mainframe Session.

Is there a way to run a macro that will take specific cell information from excel, or have access directly input, into RUMBA??

I can run macros in Excel, I can run macros in Access, I can run macros in RUMBA...... I just cant get one prog access another???

 

[Uncle Gizmo]

Surely the Rumba/AS-400 Mainframe Is capable of importing comma separated value files *.csv?

 

[HaroldIII]

Surely the Rumba/AS-400 Mainframe Is capable of importing comma separated value files *.csv?

Thank you for responding....

Im not exactly looking for a file transfer....Manually i'm coping a cell from excel and pasting it to Rumba...

when i go to record the macro....it doesnt reconize the switching screens and pasting....

But to answer your question, i believe so....I know it can be done because i saw it done at my last job....they used a comma separated *.txt file