Import data from DB2

[Mahesh]

Hi,
Is there any way to get the data from DB2. We are having a set of
queries and we want to import the output of these queries to Access tables.

I am able to import complete table data by using link table option but I
just want to get the output of the DB2 query to be imported to access. (We
tried running these queries after importing complete tables but it required
lot of modifications to the queries)

Is there any way I can get the data.

Thanks,
Mahesh

 

[John W. Vinson]

Hi,
Is there any way to get the data from DB2. We are having a set of
queries and we want to import the output of these queries to Access tables.

I am able to import complete table data by using link table option but I
just want to get the output of the DB2 query to be imported to access. (We
tried running these queries after importing complete tables but it required
lot of modifications to the queries)

Is there any way I can get the data.

YOu may be able to import the SQL of the DB2 queries - *in DB2 dialect, not
converted to Access SQL* - and run them as PassThrough queries. DB2 will
actually execute the query and return the result set.

John W. Vinson [MVP]

 

[Robert T]

Hello Mahesh:

If I were in your situation, I would purchase Alpha Five [a competitor of
Access] that makes working with back end database, such as DB2, a piece of
cake. In fact, the software is superior to Access in many ways.

Their website is www.alphasoftware.com. I think you would be intererested in
their Enterprise version.

Robert