LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Han Han is offline
external usenet poster
 
Posts: 4
Default importing Word table data into Excel - solutions for automation

I have lots of documents in Word table format. There are multiple tables of
various columns & rows in each table. Eventually, the data in the Word
tables will be loaded into a SQL database for queries and I'm lookin g to
stage the data in Excel prior to upload into SQL.

What are the methods for importing the Word table data into Excel and
automating this process for multiple Word tables within a Word file?

Is there a native tool or process to do the automation?
Or will this involve custom VB or Macro coding?

Please advise.
Thank you.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get data from a web page to chart in excel. Any solutions? goody444 Excel Discussion (Misc queries) 1 March 1st 06 06:09 AM
Excel importing of data from word BarryD Excel Discussion (Misc queries) 0 December 24th 05 10:09 PM
Automation of Excel Data to Word (ref: Galimi answers) Adam Excel Discussion (Misc queries) 3 February 28th 05 04:57 PM
Data Automation from Excel to Word Adam Excel Discussion (Misc queries) 3 February 22nd 05 02:43 PM
Excel and Word automation James[_29_] Excel Programming 1 September 10th 04 04:18 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"