Importing txt file with large number

[sumdumgai]

I am importing a delimited .txt file that has a number field. A value for a record coming in is 36,767 and Access is not accepting it. If I redefine the field as long integer or as double, I can manually update the record, but as soon as the file containing the record is imported, the field reverts back to integer.

How do I format the field with VBA so that Access will accept the value and not revert to integer?

Thanks.

 

[nanscombe]

You might want to try bringing it in as text and using a query to convert it to a Long Integer afterwards.

 

[Mile-O]

Use the TransferText method and create an Import Specification that declares the field as a Double rather than the default Long Integer.

 

[sumdumgai]

Recreating the import spec did it. Thanks,