Hi All,

This question has probably been asked before, but couldn't find a related topic. My question:

How can I import long numeric values (integers) greater than 2,147 billion (standard long integer). I tried a lot, but couldn't find the answer.

Thanks.

I think I would try to import it as a string, then take the first 3 or 4 significant digits and convert it back to an integer...

Would this work?

I think I would try to import it as a string, then take the first 3 or 4 significant digits and convert it back to an integer...

Would this work?
I tried, but after I change I to numeric it deletes those records with the very large values.

Can you use say 2.147 instead of say 2,147,000,000,000?

Can you use say 2.147 instead of say 2,147,000,000,000?
What do you mean?

I mean if you had 2.147 as a number stored in your database, could you use that number instaed of the 2,147,000,000,000 number. Does the number ever go over say 2 trillion or under 1 billion? What does the number represent in the real world and do you ever perform calculations on it?

I mean if you had 2.147 as a number stored in your database, could you use that number instaed of the 2,147,000,000,000 number. Does the number ever go over say 2 trillion or under 1 billion? What does the number represent in the real world and do you ever perform calculations on it?
Yes, it is larger then 2,147,000,000 (please note that it is not 2,147,000,000,000) etc. I have more than 50 values that are over 3 billion.

Maybe you should just use a 'single' (numeric), data type instead of and integer...