Hi ,

I am using copyfromrecrodset methond to get data from recordset to Range object of Excel 2003. It works fine with older versions of Excel like 2000, 97 etc. But for Excel 2003, the data with Char data type is not showing properly. It puts some characters into the Range object.
I am calling a stored procedure of sybase database, which returns the recordset. The table underneth has varchar, char, smallint,date data types. Only values of fields with Char data type are not copying properly to Range object. For all other datatype its works fine.

Any idea/suggestions on this one.

Thanks,
GM