I have raised a new topic on this problem, but haven't been able to resolve it. I have just read this thread tried changing my numeric formats in line with the suggestion above.

It has made no difference to my error message, but perhaps if I describe the data conversion before the excel destination, it might trigger a thought with someone.

After previous difficulties, I made all my text columns into Unicode text streams. I have some date columns and these are all database timestamp. My number columns are eight-byte signed integers, single-byte unsigned integers or two-byte signed integers.

Failing this, is there any way to find out which column(s) is/are causing the 'Cannot create an OLE DB accessor' error?