参考:
DoCmd.TransferSpreadsheet acImport, 8, "table", "d:/temp/123.xls", False, ""
指定SHEET:
DoCmd.TransferSpreadsheet acImport, 8, "TABLENAME", "d:/TEMP/123.xls", False, "sheet2!"
参考:
DoCmd.TransferSpreadsheet acImport, 8, "table", "d:/temp/123.xls", False, ""
指定SHEET:
DoCmd.TransferSpreadsheet acImport, 8, "TABLENAME", "d:/TEMP/123.xls", False, "sheet2!"