Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Import data from a Word Doc

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
US
Someone copied and pasted a WEB page into a Word doc and now we would like to import it into Access. It is laid or as a table when it pasted into Word.
The format is in two columns first column only has the name of the company.
The second column has various information from Name, Title, Address, City State zip Phone, FAX and Email. Then the next row has the next company.
Is there a way to extract this from the Word doc?

TIA

DougP, MCP, A+
[r2d2]
I love this site and all you folks that helped me over the years!
 
You can open the Word Document in OLE, navigate to the table and import each field of each record whilst iterating down the table vising vba.
 
Consider saving Word document as Text and using "Get External Data" function in Access to import the table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top