give me a hand,thank you

[big2002]

I have a Word document.I want to input this document to a database.Generally,i will create a table in a database,then input a column ,then input next column. In order to save my time,now i want to input the whole Word document by a program.
please tell me some English information about this.Or tell me web sites.Thank you!

[andyleno]

It will all depend on whats in the document ie..Bitmaps,Tables etc.
If the Document is just text then thats no problem, if the document contains multiple objects then you have a problem.

Let me know whish it is and I'll tell you where to go from there.

Don't forget to rate!!!

Andrew Lennon (Berlitz)
Automation Dev Engineer

[big2002]

The Document is just text.Thank you!!

[andyleno]

This code will open a specified Document (invisible) and loop through the activedocument to rebuild a single string for text (szwrd).
When adding this string to the database value should be a Memo Value so it's big enough to hold the string.


Dim wrd as Object
Dim szwrd as string
Dim i as Integer

i = 1

set wrd = CreateObject("Word.Application")
wrd.Visible = false
wrd.Documents.Open "C:\Temp.doc"

for i = i to wrd.ActiveDocument.Paragraphs.Count

szwrd = szwrd & wrd.ActiveDocument.Paragraphs(i).Range.Text

next i

set wrd = nothing

'ADD THIS string to YOUR DATABASE ----
'szwrd




Andy
Don't forget to rate Dude!!!


Andrew Lennon (Berlitz)
Automation Dev Engineer