import a word form to excel

[healthmj]

Here is my situation. I have build an Access database that gets records from a Microsoft Word form. I have made copies of the form and database to co-workers so they can do the same thing. I have the main database to collect all records including my co-workers. What I would like to do is have my co-workers import the word form data to an excel spreadsheet and have them e-mail me the spreadsheets. Then I would import the data from their spreadsheets into the main database. How do I make the excel spreadsheet accept the word form data so I can export the data to access?

Thanks in advance

Mike Jeansonne

 

[weetnie]

You could save the Word file as an text file and import it in Excel (through File> Open> [files of type] '*.txt'