Microsoft Access TransferSpreadsheet Function with Ms Excel Examples

This tutorial will discuss and explain about Ms Access TransferSpreadsheet function. TransferSpreadsheet function is the method to expoert and import data between Access Database, Ms. Project, or Ms. Excel. TransferSpreadsheet function is the action used in VBA module. To open Code Editor, press ALT + F11 to your keyboard.

TableName: the name of the table that wanted to be imported, exported, or linked.

FileName: the file name and path of the spreadsheet you want to import from, export to, or link to.

HasFieldNames: argument to determine the first row of spreadsheet:

True (-1): first row of the spreadsheet as field names

False (0): first row of the spreadsheet as normal data, default value.

Range: valid range of cells or the name of a range in the spreadsheet. If omitted, it will import entire spreadsheet. This argument applies only to importing, for exporting or linking you need to leave it blank.