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.
 
Back
Top