data transfer: AS400 - Windows NT

[Marco_Bottaro@xxxxxxxxxxxxx]

Listers,

I am trying to set up a reliable link between the company as400 server database
and Access on Windows NT with very limited success. I am using Client Access to
comunicate between the two systems.

Direct ODBC seems impossible, because of the lack of support on our as400-sql
for file members. Upgrading the system is not an option (costs).
The Data Transfer program looked like an alternative, but provides unreliable
results; when I compared the transferred text file with the original table on
the as400, some fields contained underscores whereas there should be simple
numbers such as '101' or '103'.

Does anybody have experience with querying an as400 system from a windows
machine without any need to reprogram the as400? I would like to stress this
last point, because there is no expertise in house for this.

Thanks in advance.

Marco Bottaro


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---