Are you trying to convert and load? Example: As Razzak said convert something_MS1.doc to a rtf something_MS1.rtf and save as a varchar in the db.
Or just load these .doc files into the db in the original .doc format? Example: something_MS1.doc > save as varchar and open it needed as > launch something_MS1.doc ||w after you output it from the table/varchar. Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: Monday, August 23, 2010 11:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - re: uploading .doc in rbase Hello Razak, thanks for the tip. But this seems to be a very 'manual' way to do it and quite achievable for a small number of documents. However I have to read more than 80.000 word-documents into the database. It then seems not an option to do this manually. Isn't there a way to automate this and speed things up ? Luc D. -------------------------------------------------- From: "A. Razzak Memon" <[email protected]> Sent: Monday, August 23, 2010 5:19 PM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - re: uploading .doc in rbase > At 10:34 AM 8/23/2010, Luc Delcoigne wrote: > >>in my Access > Rbase conversion I have come to the point that I have >>to load .doc files into the varchar field of an rbase table. >> >>What would be the most elegant way to this, considering there are more >>than 80.000 files to upload in the table....? > > Luc, > > Here's how I have converted/stored all .doc files into R:BASE. > > 01. Open the original .doc file(s) in MS Word and then save as > .RTF to preserve the original formatting, etc. > > 02. Then, load these .rtf file(s) in R:BASE as VARCHAR or BLOB > (VARBIT) data type. > > Use the appropriate data type (VARCHAR/VARBIT) accordingly. > > 03. Once stored in R:BASE, you may take advantage of enhanced > Blob Editor to manage all your documents, etc. > > Tip: > > When using the enhanced R:BASE BLOB Editor, make sure to > select [Rich Text] option/tab to manage .rtf files. > > 04. To print these documents in R:BASE eXtreme 9.0 reports, > make sure to use Advanced DB Rich Text Control. > > That's all there is to it! > > 2010 Annual R:BASE Conference Highlights include a session to > demonstrate the use of such features in R:BASE eXtreme 9.0. > http://www.rbase.com/conference/ > > Very Best R:egards, > > Razzak. > >
