I would guess that you tried to drag and drop the .csv file onto the icon or shortcut for the FileMaker application. This converts the file into a fileamaker file. To get all of these records into a single FileMaker file, Open or create a fileMaker file and use Import Records to import the data.
There's a known issue with importing data from very large .csv files into FileMaker. If your files are larger than a certain size, you may need to split up your data into smaller files.
For More Information see: Import of a large CSV file halts after 4GB
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: https://www.dropbox.com/s/jt09b82i0xijbu3/FMP%20Bugs.zip
Thank you I am getting some traction here now and as for the size limit I learned about that first off. Filemaker does not like large databases when loading and I found with my data anyway a max of one million records at a time works well with no problems