MS Query cuts out certain parts of fields

Mats Carlsson · Apr 24th 2003

Hi!

I am trying to connect my Sybase SQL Anywhere with XL. The info looks ok in Query but when its dumped into XL some info in some fields are missing, for instance the first 5 positions of a number is shown but not the remaining 5 (its an ISBN) is cut out. Anyone got a clue?

TIA /Mats:flower:

PS. Is it worth the time and effort to learn MS QUERY or should one try SQL*XL?

**Jack in the UK** · Apr 24th 2003

Are you setting a condition or criteria to the filed down load?

I assume your using M$ Query

Kind regards

Jack in the UK

Mats Carlsson · Apr 25th 2003

Hi Jack!

Thanks for your interest!

Yes I am setting a criteria, but not on that field. Today I tried a weird way of doing this. In MS Query I marked all posts copied them then went into Xl and did a paste-values and the whole number is there, but unfourtunatly a whole lot more difficult to update.

/Mats

MS Query cuts out certain parts of fields

Participate now!

Share