>>>I tested with the beta 10 version that I sent to you and the return values are correct. Please see the attached screen shot.
>>
>>Thank you.
>
>BTW -- there are two methods for exporting a table to a workbook. The first method (which you are using) is SaveTableToWorkbook(); this method saves the table into the internal xl_* named cursors. This allows you to be able to add formatting and other features to the workbook before saving. But this is the slowest method to saving a workbook. The second method is SaveTableToWorkbookEx() which saves the table directly to the workbook with limited formatting. The formatting is defaulted by field type and font name/size is set as a property value. This is a much faster output to create the workbook.
I will try both methods and compare. The speed is not really important to me. The accuracy and preserving the column types is.
Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham