如何指定TransferSpreadsheet方法中工作簿中的工作表
TransferSpreadsheet的语法:
docmd。传输电子表格传输类型,电子表格类型,表名,文件名,hasfieldnames,范围,useoa
对于Excel,Range的用法如下:
" "(空 string):表示工作簿的第一张工作表;
“Sheet1!A1:D10”:表示工作表Sheet1的A1到D10区域;
" Sheet2!":指示整个Sheet2工作表。
例如:
通过TransferSpreadsheet方法将Book1的Sheet1和Sheet2导入Access mdb。
Docmd。TransferSpreadsheet acImport," temp1 "," C:\Book1.xls ",False," Sheet1!"
Docmd。TransferSpreadsheet acImport," temp2 "," C:\Book1.xls ",False," Sheet2!"
0条评论