If you enter a range, the export will fail. When you export to a spreadsheet, you must leave this argument blank. Leave this argument blank to import the entire spreadsheet. When you export Access table or select query data to a spreadsheet, the field names are inserted into the first row of the spreadsheet no matter what you enter for this argument.Ī string expression that's a valid range of cells or the name of a range in the spreadsheet. If you leave this argument blank, the default ( False) is assumed. Use False (0) to treat the first row of the spreadsheet as normal data. Use True (1) to use the first row of the spreadsheet as field names when importing or linking. The type of spreadsheet to import from, export to, or link to.Ī string expression that is the name of the Office Access table that you want to import spreadsheet data into, export spreadsheet data from, or link spreadsheet data to, or the Access select query whose results you want to export to a spreadsheet.Ī string expression that's the file name and path of the spreadsheet that you want to import from, export to, or link to. The type of transfer that you want to make. TransferSpreadsheet ( TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)Įxpression A variable that represents a DoCmd object. The TransferSpreadsheet method carries out the TransferSpreadsheet action in Visual Basic.
0 Comments
Leave a Reply. |