how can I export data from a Microsoft Word document to Excel or access?

Question

I have numerous forms in word format. i wanna convert these form entries into a excel database...

Answer 1

Open the word document and click on File > send to > now select where u want to sent it



In excel click in Data > import external data and select ur word doc

Answer 2

Your form is a template. This is analagous to an Access database table's schema - the collection of fields in each record. You have a field for name, date, type of contraband siezed, etc. The form is completed, and this becomes a record. All the records together make up a table - one for each form. All the tables together make up a database.



In Excel, each form's field names are entered as column headers in the first row, and the individual records are entered one row at a time. One form per worksheet.



While it is theoretically possible for you to simply import your completed word documents into either Excel or Access, the likelyhood that you have prepared your Word documents to support this type of import is slim to none. Data imports of this type are generally performed from simple ASCII files that have a delimeter - a unique character that seperates one field-value from another, and have only a single record on each row.



You may be able to edit your individual word files into a master .TXT file (by form type) that can be used to serve as a data import, and save yourself the trouble of actually having to rekey everything.n



Database programmers make good money doing this kind of work so you don't have to.

Answer 3

If it's set up right, you can use that spreadsheet as data for Word's Mail Merge feature to print the labels. Far too much to go through here, so I'll just give a few tips: 1. Word's Mail Merge can be found in the Tools->Letters and Mailings menu item in early versions of Word, or on the Mailings tab on the ribbon in Word 2007. 2. For the most flexibility with the mail merge fields in Word, keep first and last names in separate cells. Ditto for the parts of the address (street address, city, state, zip). 3. Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout. 4. Don't leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think. 5. For test runs, use only enough names to be sure you're not losing any -- a little over a page should do. Accidentally skipping every other name is real easy to do. Keep a sense of humor while you're wrestling with it. It will be worth it the second time around. Hope that helps.

Answer 4

http://openoffice.org



http://pclinuxos.com



all free, import/export all Microsoft Word files since 1986.

Try that with your EXPENSIVE Microsoft Office!

Answer 5

try and import it!