You could open the spreadsheet using the excel api and skip the datatable entirely. There should be plenty of info available on this forum and the web in general. If you have specific questions, though, let us know.
Set xl = CreateObject("Excel.Application")
xl.DisplayAlerts = false
set book = xl.Workbooks.Open(filepath & filename)