Need to Import 4M rows from a csv file into FM Pro 12
I have a csv file with 4M rows in it. When I try to import this file, it will only import 158772 rows. The first recod contains the column names and the rest are the rows of data. It looks like it is bringing them in fine. Is there a setting somewhere that I have to change to bring in all the rows from the file? I have attempted to 'Convert from Existing File" and also "Create a New Database", then import on the create. For both of the ways I have tried, I am getting the same results.
Any help would be greatly appreciated or am I using the wrong type of database product? I have tried Access 2010 and it will not more than 2M rows. I would really appreciate some hep with this. Thanx in advance.