I know the way to download data from as400 to excel 2007.
It can be done by using Data connection wizard or Microsoft query.
However, when using
Data connection wizard, i don't know which kind of database i should choose.
ODBC DSN or Other / advanced ?
after choosing the kind of database, how can I know the name of the database I need to choose?
when using Microsoft query, which driver I should choose?