clarksonneo
05-09-2011, 09:47 AM
Hi,
First of all, this is not a vba question. I hope it is still correct to ask in this forum.
I know the way to download data from as400 to excel.
It can be done by using Data connection wizard or Microsoft query.
However, when using
(1)
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?
(2)
when using Microsoft query, which driver I should choose?
thanks
First of all, this is not a vba question. I hope it is still correct to ask in this forum.
I know the way to download data from as400 to excel.
It can be done by using Data connection wizard or Microsoft query.
However, when using
(1)
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?
(2)
when using Microsoft query, which driver I should choose?
thanks