Increasing range of long integer in Access

[Guest]

Is there any way of increasing the long integer field? I am trying to import
records that include primary keys of 2603200022, 2594797024. Access fails to
import the fields and I think that is because they are outside the allowed
range – 2,147,483,648 to 2,147,483,647. I'm using Access 2000.

 

[Ken Snell [MVP]]

No, but you could import them as text or as double.