Incomplete query return, who can help?

[GorKo]

My locally open worksheet has a query that is supposed to sync it with
a multicolumn named range of another worksheet on a server.
Everything syncs fine except one column containing zeros or short text
(2-9 characters).
Zeros get synced instead of text i get blank cell. See a sample below:

Source:
Detail Pref Time COD
Pressure Pad & Pump, 2 PM, 12-4 $0.00
Patient Lift , Trapeze , 1 PM12-4 $0.00
RT, 10195 0 $0.00
RT, 10195 0 $0.00

Destination:
Detail Prefs: 169904 Time COD
Pressure Pad & Pump, 2 $0.00
Patient Lift , Trapeze , 1 $0.00
RT, 10195 0 $0.00
RT, 10195 0 $0.00

In destination rows information: PM, 12-4 and PM12-4 is missing.

Anyone can figure it out?

Georgee

 

[Guest]

Maybe something in these. Read Dick's Blog first:

http://www.dicks-blog.com/archives/2004/06/03/external-data-mixed-data-types/

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819
How To Use ADO with Excel Data from Visual Basic or VBA