Data Field Problem

C

carl

I am creating a table by importing a csv file. This field is not importing
correctly - Error / Type Conversion Failure.

Here's the data before importing:

0000002751620397
0000002751620397
0000002751626082
0000002751626082
0000002751632460
0000002751632460

I need this field to be an interger so I can perform a pivot table average
on it.

Thank you in advance.
 
D

Douglas J. Steele

Can't be done using an Integer nor Long Integer.

Integer fields can only hold values between -32,768 and 32,767, Long Integer
fields can only hold values between -2,147,483,648 and 2,147,483,647
 
C

carl

thank you. any suggestions ?

Douglas J. Steele said:
Can't be done using an Integer nor Long Integer.

Integer fields can only hold values between -32,768 and 32,767, Long Integer
fields can only hold values between -2,147,483,648 and 2,147,483,647
Click to expand...
 
Top