Import data from DB2

[Guest]

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

 

[Joseph Meehan]

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

Ask the DB2 people to provide you with a fixed length or delineated
(comma is usually good if the data has no commas) file and you will be able
to import from that.

 

[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]

 

[Guest]

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