Data Field Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top