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

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

http://www.dicks-blog.com/archives/2...ed-data-types/

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

--
Regards,
Tom Ogilvy


"GorKo" wrote:

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