MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel sheet to access as object

Posted by Gerot on June 26, 2001 9:45 AM

Hei folks,

how can I transfer a sheet from excel containing an array of numbers and insert it in access 2000 as object using VBA.

Thanks, Gernot

Posted by Don on July 10, 2001 1:37 PM

Have you tried the TransferSpreadSheet command?