Access: DoCmd.Transfer… methods

There are a few transfer… commands that allow to export and import data from/to Access:

• transferDatabase
• transferSharePointList
• transferSpreadsheet
• transferSQLDatabase
• transferText

Under the hood, these methods use Microsoft Access database engine for the export and import, see Microsoft OLE DB Provider for Microsoft Access database engine.

A VBA example that demonstrates DoCmd.TransferSpreadsheet is here.

Compare these methods with DoCmd.OutputTo ….