The TransferSpreadsheet command with the acImport option can also be used to import a spreadsheet into an
Access table. With Office/
Excel automation, you can actually open an existing
Excel spreadsheet from
Microsoft Access, and place data in specific cells, thereby automating the updates of the data there.
read more >>