RE: Getting records from a MS Access database

[boothm@xxxxxxx]

Scott, thanks for the tip.  I was going to download that 40 meg service
pack on the weekend but I guess I'll do it tonight instead. 

Gads...  giving them the data from both places in one application is a
mind-blower.  I think this time they may be speechless, and making
salesmen speechless is quite something.  I sure hope the ODBC part works
as well as the other stuff has so far.


In <01BD9E75.D5CA2940@sjohnson.highsmith.com>, on 06/23/98 
   at 07:09 AM, Scott Johnson <sjohnson@highsmith.com> said:

>Booth,

>Put that new version of VARPG you just got to good use!!

>With Service Pack 3, you can use the new ODBC part to
>connect to the MS Access database.  Mean while at the
>same time connecting to the AS/400.  You can then read the
>Access file, massage the data if needed, and output it to the file on the
>AS/400.
>On the VARPG webpage there is a sample ODBC app.
>--  
>------------------------------------------------------
>Scott P. Johnson
>Programmer/Analyst
>IBM Certified Specialist - AS/400 RPG Programmer
>Highsmith Inc.
>W5527 Hwy 106, PO BOX 800
>Fort Atkinson, WI 53538-0800
>TEL:  920-563-9571                FAX:  920-563-7395
>sjohnson@highsmith.com
>www.highsmith.com
>------------------------------------------------------
>----------
>From:  boothm@ibm.net[SMTP:boothm@ibm.net]
>Sent:  Monday, June 22, 1998 6:47 PM
>To:    MIDRANGE-L@midrange.com
>Subject:       Getting records from a MS Access database

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

>tia


-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

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