Anyone know of a good package that will open a text file and display the line number you are looking at????? Be great if it was free (Not to the programmer though)???


I have a text file with 100,000 records. I try and pull it into a SQL server but it errors out and gives me the line number (83,001). However, I do not have a way to look at that line to see what the problem is. I had someone with AS400 access pull the file in and for some reason the AS400 will do it and not error. He looked at line 83,001 and it indeed had a problem with respect to bad quote marks. I want to be able to fix the problem myself rather than having him take this step every week when a new text file arrives. I am looking to correct the text file at the source but would like a fix in the mean time.

If I try and use the LINE INPUT function it can not open file and errors out. I believe because it is to large.

Thanks