AnsweredAssumed Answered

Need to Import 4M rows from a csv file into FM Pro 12

Question asked by JerryBall on Jul 21, 2012
Latest reply on Jul 21, 2012 by JerryBall

Title

Need to Import 4M rows from a csv file into FM Pro 12

Post

Everyone,

  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.

Jerry

Outcomes