Import .txt file to Access....

[Cordury]

Good Morning,

I have a couple of very large txt files (phone records) that I am attempting to import into Access. These files have no header row. The fields that should be named "Number called from" and "Number called to" are simply phone numbers with no dashes or ()'s.

For some reason, these two field which are set up as Long Integers will not import and I get a table with all of the errors for both numbers with nothing in the fields.

Any ideas?

Thank you

 

[Cordury]

I changed the phone numbers from Long Integer to text and that seemed to do the trick.

Thanks anyway!