What is the total size of the file? (I think there's an upper limit to how large a csv file that can be imported.)
A csv (comma separated values) text file is one of the standard file formats that can used with import records to import this data so if the file isn't too large, you can just use Import Records to pull this data into a table in FileMaker. If it's too large, you may need to split the file into two or more smaller sized files and import one at a time into FileMaker.
My issue is it is putting the whole thing on the 1st line in my table.
My bad i should have been clear... the file size is 124 MB
File size limit that I recall is in the Gigabyte range so 124 MB shouldn't be a problem. What you show is not what I would expect to see if you specify importing a csv file. When you select Import Records and get the dialog to select the file, select the csv file option from the "files of type" drop down in the dialog.
And what you show doesn't seem to have any zip codes so your statement:
its a zip code to zip code file.
Is mildly puzzling
That worked, thank you.
Its the 1st 3 digits of the zip...