Transfer text/spreadsheet to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I transfer a text and a spreadsheet from MS-Word and MS-Excel to an
Access database?
 
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.
 
Back
Top