Transfer text/spreadsheet to Access

[Greg]

How can I transfer a text and a spreadsheet from MS-Word and MS-Excel to an
Access database?

 

[Klatuu]

To import an Excel spreadsheet, use the TransferSpreadsheet method.
Importing from a Word document is a little different. Someone may have a
more elegant solution, but the simplest way is to save the Word document as a
text file, create an Import Specificaton for the text file format, and use
the TransferText method.