Don wrote: > > Let me take this a step further... > > We've got a client that's made the transition from OV/400 to > Wordperfect... Now the hitch...they want to be able to import via ODBC > fields direct from the PF/LF's on the 400 into their documents... I've > not been able to find anyone that knows how to do this... ANy ideas?? CAN > it be done?? > Don, We do this all the time, although it is a 2 step process. On the PC we create an Excell spread sheet that receives external data via ODBC. This inturns automatically runs Microsoft Query on the PC that defines which records we want loaded into the file. Once this is done we save it. From that point on, all you do is open the spreadsheet and go to the DATA option and select refresh data. It will then go to the AS/400 and update the records in the spread sheet. We then open a Mail merge Word document (which I am sure you can do in Word perfect), and it automatically fills in the information. I know that the ladies in Marketing run this every day to send out mailings to everyone that they have talked to that day. HTH -- Pete Massiello OS Solutions International Phone: (203)-744-7854 Ext 11. http://www.os-solutions.com mailto:firstname.lastname@example.org +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MAJORDOMO@midrange.com | and specify 'unsubscribe MIDRANGE-L' in the body of your message. | Questions should be directed to the list owner/operator: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.