Terminé

Extract data from MS Word form fields into MS Access table

**Objective:**

To automatically fill an MS Access table with data extracted from several word documents with form defined fields

**Description:**

I have developed a word document with lots of form defined fields (near 1000). I now have some 500 word files filled in and I need to compile all the data into an empty MS Access document, one row per file, one column per field.

Also, I want to have an access page to the data in the tables: a window very similar in layout to the original word files where I can move between records with a toggle button.

## Deliverables

I need a macro or small app that opens up a "windows explorer" like window for me to select the folder where several word files are and then extract their content into one MS Access file with as many tables as required (because of the 255 field limit per table), one row per file, one column per field.

Attached are 6 example files for testing.

**Additional considerations:****

**1. On the first column of every table the input must be the file name that is originating that record.

2. Because when some fields were filled in people used the “Enter?? key (ex: filling in an address with two lines using only one field), the line break must be deleted and replaced by a simple space, so that all the info from a given field remains together.

3. Some of the word files are password protected, but can be access in read only.

4. The word files must not be changed in the process.

5. If the macro/app finds a file with the same name as one already in the database, it should issue a warning asking if I want to overwrite the existing record, add a new one (adding a “2?? to the end of the filename in the database so I can tell them apart), or combine both (updating the information that is different from the existing one, assuming that if previously there was some information in a given field and now there is none, the field must be left as was).

6. If a problem occurs with some file, the macro/app should skip it and when it is finished create a text document with a list of errors, stating the file names and error type (with a description intelligible for non computer experts).

7. an access page to the data in the tables must exist: a window very similar in layout to the original word files where I can move between records with a toggle button and edit them.

7.1 this page should also have a "search" possibility, allowing me to go directly to any given record by searching the database through any of its fields. If the search returns multiple records, I should be able to move only through that short list.

**General terms**

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP

MS Word 2003

MS Access 2003

Compétences : PHP

en voir plus : terms of agreement form, software testing space, skip searching, php source code testing software name, one key data, new hire information form, ms new hire, ms access with php, i want to edit word document, database one word or two, access experts, access database experts, 1000 word document, is into one word, fill in form word, create macro in word, combine two word documents, ms access experts, word input, password break

Concernant l'employeur :
( 3 commentaires ) Portugal

Nº du projet : #3927469

Décerné à:

arsenind

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 12 jours
(8 Commentaires)
2.9

17 freelance font une offre moyenne de $110 pour ce travail

GetReal

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(312 Commentaires)
7.3
pShankar2

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(410 Commentaires)
7.1
Premshanks

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(356 Commentaires)
6.5
rackingcoder

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(36 Commentaires)
6.1
Wonderer

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(82 Commentaires)
5.9
henryli2008

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(22 Commentaires)
5.4
vw2244935vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(39 Commentaires)
4.5
softlakecity

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(24 Commentaires)
4.2
shraddhamit

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(8 Commentaires)
4.2
blackrosezy

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(15 Commentaires)
3.5
raduboriga

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(5 Commentaires)
3.3
schamara

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(8 Commentaires)
2.9
ragavendra1108vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(3 Commentaires)
2.6
shanojbabu

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)
0.0
vw2266029vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)
0.0
gustavoe

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)
0.0
ygkchaitu

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(2 Commentaires)
0.0