Import Words Tables/XCEL spreadsheet

M

marilyn

Is there a way that I can programmatically import word
tables and data entered into XCEL spreadsheets?
 
P

PC Datasheet

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.
 

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
Linking data in MS Word into Excel 5
Converting PP and Xcel Documents to Word 5
Booklet in Word, Merge Directory from Excel 0
does xcel have a built in scheduler ? 2
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Amalgamating similar tables 1
paste cell from xcel document 3

Top