Importing Problem

[fmsavey]

Today I tried importing a text file that was approximately 9000 records so that I could parse out some information. After importing the file I noticed that only 7413 records were imported. I did this a couple of times with the same results. Finally I went to the last record in the db and click in it and discovered that the last thousand or so records from the text file loaded into the last record of the db.

HAS ANYONE HAD THIS EXPERIENCE. How can this happen? Are there hidden control characters in the text file causing this. When I look at the text file in WordPad it displays all the records without any problems.

Any suggestions on how I can resolve this.

[fmsavey]

Problem solved. I began to experiment by first importing the file into FM6 and everything loaded just fine. After the import I had 14,000 + records more then I originally thought there were. Switching back and forth between FM8 and FM6 I realized that sometimes hundreds of records that appeared in the FM6 file had loaded into just one record of the FM8 file. When I imported the files into both versions the open dialogue had the "File Type" set to "All Files (*.*)". I then renamed the file I was importing with a .txt extension and then imported it again into FM8 this time I choose the file type of "Tab Separated Text File (.tab, .txt)". After the import completed the file loaded as expected. Apparently FM8 uses a different set of rules depending on the file type you choose.