Very broadly, you can use GETFILE() to prompt the user to select a single file they want to upload or if it's an entire folder, you could load all the DOC files in that location into an array and then iterate through that. Use FILETOSTR() to dump the DOC into a memvar and then insert into SQL as Steve mentioned. You'd probably have to make sure that SQL is not set to automatically perform character translation because it would probably turn that string into an unreadable mess. To retrieve the doc, you'd do the reverse. Get the file name from the user. Retrieve it from SQL and use STRTOFILE() to dump it back out to disk. Use automation to fire up Word with the retrieved document.
rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: Friday, May 28, 2010 8:51 AM To: [email protected] Subject: Re: VFP and SQL Server + Word files But I still need the "push code into VFP and out" Rafael Copquin _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd04406841ab...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
