Import Words Tables/XCEL spreadsheet

  • Thread starter Thread starter marilyn
  • Start date Start date
M

marilyn

Is there a way that I can programmatically import word
tables and data entered into XCEL spreadsheets?
 
For Word ------
Convert Table In Word To An Access Table

1.. Convert the Word table to text, separated by commas (Table - Convert -
Table To Text)
2.. Copy & paste the whole lot into Excel - make sure everything is in the
right columns (Excel has some functionality which makes some things easier
to do here than in Word)
3.. Save it as a *.csv file
4.. Open Access. Use File - Get External Data - Import to bring the *.csv
file into a table
Step 4 can be done in code - see TransferTexr method in Help file.

For Excel ------
See TransferSpreadsheet method in Help file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inserting xcel worksheet 2
Amalgamating similar tables 1
Auto Character Assignment 1
Converting PP and Xcel Documents to Word 5
ppt2007 viewer 3
paste cell from xcel document 3
Why on Xcell I put in a figure hit enter and it reads out ### 2
xcel docs open encoded 3

Back
Top