Automatic transfer AS400- > Excel

[Warzel]

Hello

I am trying to transfer data from an AS400 system to a Excel sheet,
Now this is done manually by cliking the add-in from Client Access named
CWBTFXLA.XLL
This works but the data has to be formatted afterwards,
I want to make the transfer automatic via VBA en then run some code on it.

The formating code works but i can't get the automatic transfer to work.

Pse help

 

[Fredrik Wahlgren]

Hello

I am trying to transfer data from an AS400 system to a Excel sheet,
Now this is done manually by clicking the add-in from Client Access named
CWBTFXLA.XLL
This works but the data has to be formatted afterwards,
I want to make the transfer automatic via VBA en then run some code on it.

The formating code works but i can't get the automatic transfer to work.

Pse help

You should be able to set up an ODBC connection to the AS400 system. Having
done that, you can get data by making an SQL query. How does the data come
out now? In what way does it have to be formatted?

/Fredrik