Re: Getting records from a MS Access database

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 12:12 AM 6/23/1998 -0400, you wrote:
>In <3.0.5.32.19980622224904.00998b30@goldengate.net>, on 06/22/98 
>   at 10:49 PM, Vernon Hamberg <hambergv@goldengate.net> said:
>
>>Booth
>
>>At 07:47 PM 6/22/1998 -0400, you wrote:
>>>Is there a good way to retreive a MS Access database with 650 records in
>>>it where the records have something approaching 60 fields, and the fields
>>>appear to be of varying length?
>
>>More information, please. Retrieve to what?
>
>oh, sorry.  to the AS/400 database.  As a file that I can use to tie into
>the rest of the information we have.

OK. You've hit a subject that I feel is not covered enough—using the 400 as
a _client_ to other RDBMS's, like SQL Server, Oracle, or, here, MS Access.
The discussion always assumes the 400 is the server.

Having said that, here's an idea. You can write a module or macro (forget
which) in Access that can do almost any Access command. What I'm thinking
of is something that creates output of the Access table to, say, a text
file. Then this could be transferred with FTP or ?. And it could be done
batchwise with RUNRMTCMD from the 400, starting Access with that
macro/module. Maybe?

HTH
Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| 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
+---