I ha a strange problem. I download a list of phone numbers from the state of Texas for a DO Not Call. The file comes is a .txt format tab delimited, so I use the open method "File----Open" and have it open the file. MS Access 2003 goes through the steps to import the file to a access table but a good portion of the file is lost in the conversion.
Area Code Phone Number Date XXX xxxxxxxxxx xx/xx/xxxx I get the first 1400 complete information but after that it drops off the phone number field only. Area Code Phone Number Date 210 210XXXXXXX XX/XX/XXXX 512 #NUM! XX/XX/XXXX is there a limit to the number of records that can be imported to a database or is it something else. The fileds are labled in access as Filed1 Field2 Field3 Text Number Date/Time I checked the original Txt file and all the entries have the correct information. the total textfile has over 11 Milion entries.
