T
Tim Long
Hello, I am using Access 97. Could anyone please tell me how I can get the
name of an active Excel workbook and use it to import the data into an Access
table (called "SLR") using the following? Also, how can I import the contents
of a particular worksheet in that workbook if it contains more than one
worksheet??
DoCmd.TransferSpreadsheet acImport, 3, "SLR"," name of spreadsheet ", True,
Secondly, could anyone tell me how I can export an Access table to a
particular sheet in a workbook?
Any help would be much appreciated!
Many thanks in advance
Tim Long
name of an active Excel workbook and use it to import the data into an Access
table (called "SLR") using the following? Also, how can I import the contents
of a particular worksheet in that workbook if it contains more than one
worksheet??
DoCmd.TransferSpreadsheet acImport, 3, "SLR"," name of spreadsheet ", True,
Secondly, could anyone tell me how I can export an Access table to a
particular sheet in a workbook?
Any help would be much appreciated!
Many thanks in advance
Tim Long