Thank you very much, that solved my problem.

Apparently I don't know yet how to look efficiently in the
MS KB...

Thanks again,
Stefen.

-----Original Message-----

Stefen..

see http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q222120

setting connection.cursorlocation=aduseclient seems to
solve problem.
else post back with
exact driver names and versions and i'll help you search.
or post in ms.public.data.ado


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Stefen Percoco wrote :

I am trying to collect datas from a Sybase DB and to
populate a ADODB Recordset with those datas. I inconter
the following problem : all numbers have their zeros at
the right removed. For example, a 1000 in my Sybase DB
will appear in my Recordset as 1.

Has anyone already incontered this kind of issue ?

I precise that I am working with Excel 2002 on Windows
XP
and that my spreadsheet worked perfectly with Excel 97
under Windows NT.

Thanks in advance for your help.

Stefen.

.