Using ADO Connection to Copy Data From Multiple Workbooks Help

[JKwan]

yes you can, you use :
Select * From [Sheet1$]