Alternate method to transfer spreadsheet than DOCMD.TRANSFERSPREADSHEET
Posted on 2004-08-04
I currently have some code to transfer all the contents of an excel spreadsheet:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblname", filename, True
I however want to transfer only a specific range within one of the worksheets found in the workbook.
Is there anyway to accomplish this...I ahve also been reading that there is a dao method??? Can anyone give me any insight on how I would accomplish this?