i tested first with to rows and it was successful. this error popped up with 24999 rows. doesnt make sense to me

Have you tracked down the line in error? Maybe you have a comma in the data that is throwing the columns?