Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-19-2013, 01:21 PM
shoro shoro is offline Data transfer from Word tables to Excel Windows XP Data transfer from Word tables to Excel Office 2003
Novice
Data transfer from Word tables to Excel
 
Join Date: May 2012
Posts: 2
shoro is on a distinguished road
Default Data transfer from Word tables to Excel

I received Word 2003 data files and I am trying to pull the data from it and import in Excel in tabular format. The challenge is the way Word document is formatted with field names and data appearing side by side and with description field has data appearing below the field name. I want to be able to put this into datasheet format to maintain a small database.

sample layout:

ID: 12344, Sponsor: Mr abc
Business line: business1 Head Sponsor: Mr zee
country: lalaland
description:
this record is different

ID: 12345, Sponsor: Mr efc
Business line: business3 Head Sponsor: Mr Kay
country: seasame
description:
Another weird format

Can anyone please suggest as to what would be best way to extract data accurately.
Thanks
shoro
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data transfer from Word tables to Excel how to transfer multiple excel cells into specific place in word document by formulas anton Excel 1 12-20-2011 03:56 AM
Data transfer from Word tables to Excel How to create an Excel add in that will automatically build tables from data selvamariappan Excel Programming 1 12-12-2011 03:11 AM
Data transfer from Word tables to Excel Is it possilble to transfer data from Excel to Publisher? markhuges Publisher 8 10-23-2011 05:55 AM
How to transfer Word 2003 Tables to Excel? steeleye Word Tables 1 07-10-2009 04:18 PM
Data transfer from Word tables to Excel How to transfer multiple cells from excel to word by formulas justziggy Word 5 05-23-2009 02:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft