We perform similar functions and how we accomplish that task is to insert the data using a oledb connection like this:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFile & ";Extended Properties=Excel 8.0;

With...