PDA

View Full Version : Data connection wizard / Microsoft query



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