CopyFromRecordSet has Invalid Cast Exception

I have a dataset produced from an SQL script and I am trying to output one column to a column in Excel. The record set produces one column with a max of 228 records at any given time.

Currently this is the code that I am using (in the code i is the excel column number which is always set ):

myWkBook.Sheets(Row.Item("intTypeSort")).Cells(5, i).CopyFromRecordset(myResultsDS.Tables(0))

I am being thrown the error:

No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))

Any ideas?

The way I've added a value to Excel is to do: worksheet.Cells(5, i).value = "SomeValue"

So you could loop through your DataSet and add the values manually.

I'm not to sure what Row.Item("intTypeSort") is trying to do.