Need Help with Large Project

[jesus4u]

I also posted this question in the VB Section. Here goes!

Ok this is the deal. I have never used Word in a VB APPLICATION. What I have been assigned to seems impossible. I have a large book 2,000 Word documents long. The book contains quotations from all the past Presidents of the U.S. and historical documents. Each entry needs to become a new record in an Access DB. I am wondering how to create a routine to search these docs and make the new records in the DB.

There is a type of pattern when the author typed the book in Word.
Here it is!

The quotations are arranged chronologically, beginning with the Magna Carta 1215 AD, and continuing up to the present.
quotes from each of 42 U.S. Presidents
50 State Constitutions
Acts of Congress
Supreme Court decisions
State Legislatures
State Supreme Courts
Senators
Congressmen
Statesmen
Military Leaders
Musicians
Educators
Scientists
Reformers
Journalists
Pioneers
Explorers
Women Leaders
Black Leaders
Colonial Charters
event date
birth date
death date

Entries are arranged in chronological order by birth, date of inception or date of signing.
There are three hard returns [HRT] between each entry.
Each entry begins with the bolded [F6] entry title (last name, first name) then date, comma, followed by historical/biographical information, colon, the quotation(s), and endnote(s).
All quotations are indented [INDENT] and begin with a tab [TAB].
*Each quotation has an endnote [Ctrl F7 2 2] at the end, as well as portions of the historical/biographical information.
*Each endnote begins with the entry title first, (last name, first name), then a period, then the date of the quote or entry, a brief description, followed by the sources referenced and, in some cases, additional information.
*All book titles in the main text and in the endnotes are in italics [F8 2 4].

[Criki]

Wow, that's a lot to take in.

My idea would be to have vb open the document and then loop through each line. Inside the loop create a select case statement that would catch any of the details that you listed above (the tab, the hard returns, etc) and then have each case save the result from the line into a variable so you can pass a full record to the database.

Help any?

[jesus4u]

yes that helps. With much discussion we are going to parse it from a text file. It is working pretty good. I just need to write some more logic.