Missing filed data on Import

[Guest]

I've imported a 215000 row txt file with only 3 fields. The quantity field's
datatype is set to long integer and contains data from 0-9999. On import to a
table, I receive no import errors- but all rows containing a 4 digit numbers
(ie. 1222,3102,2727) only import the first positon(1,3,2). All other lengths
come in fine. I have checked my options and my default number type is long
integer. I've even changed to currency hoping to get a 6 digit number w/2
decimal places. But - not happenning.

I've never seen this before. My export (from MBS Navision) text file clearly
shows these records as 4 digit numbers.

Thanks!

 

[Guest]

Hi Jacki,

Try importing the text file again. When you get to the first screen of the
Import Text Wizard, click the Advanced button towards the lower right. There
you can better fine tune the import plus save the import specification if you
ever need to import a similar text file.

 

[John Nurick]

Hi Jacki,

My first thought was that the 4-digit numbers include thousands
separators. Is that the case?

 

[Guest]

I brought in those quantities which are >1000 and I was able to see that
indeed there is a thousandths separator which I did not see before.

Thank you so much!