Word to dbf ?

[ShyFox]

Hy,
I faced for the first time with a situation: a firm has a lot of datas into word files. this word files have a header too (e.g. man | women | childs).
My question will be if Fox can import the *.doc format into dbf? Or an excell file, at least???
Regards

As I go deeper the road seems to go further. We're just simply pasangers on the road of knowledge.

 

[monikai]

I think *.docC can't import to *.dbf, but if you write it as txt - you can. The xls files can be import to dbf (eg:
by wizard)
Regards

Monika from Warszawa (Poland)
(monikai@yahoo.com)

 

[ramani]

Hi SHyFox,

If the documents are saved as txt files with consistency as to the length of data elements, you can import into dbf files by creating a prg to read the strings and then convert into your fields.

xls formats can be imported



ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[Mike Gagnon]

ShyFox

Another option would be to automate Word and store the whole document in a string and parse it.

oWord=CREATEOBJECT("word.application")
oWord.Documents.Open("c:\doc4.doc")
oSelection=oWord.Selection
oSelection.WholeStory && Select all
myString =oselection.Text && Store in a variable

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[monikai]

You can use (i use VFP6):
IMPORT FROM NameOfXls(with path) XL5 SHEET NameOfSheet

Name of Fields in DBF are as column (A, B, ..., AB, ..., IV)


Monika from Warszawa (Poland)
(monikai@yahoo.com)

 

[ShyFox]

First: I thank you all.
Second: the word file it's in fact a report.
Why? Because it shows something like:



Field one Field two Field three
-------------------------------------
blabla bla etc
la a tc
page 1 of n

and so on...

So the data is not formated, but Ishall try to make it in a txt and from there to build it in a free table.
Regards


As I go deeper the road seems to go further. We're just simply pasangers on the road of knowledge.