Transferspreadsheet

[Bill Gower]

From an Access Macro how do I transfer a specific worksheet into an access
table?

Bill

 

[Ken Snell \(MVP\)]

Specify the worksheet name (followed by !) in the Range argument:

SheetName!

 

[Guest]

use the action :TRANSFERSPREADSHEET selecting IMPORT