I have searched high and low to solve this problem.
I was trying to import a large text file to a table. The text file has more that 1 million lines. The table has only 1 column to hold one line from the text file. I made sure that the CLEAR TABLE is checked before I start the process. Commit every 100.
When I checked the resulting table, I noticed that it reoganized the sequence of lines from the text file.
For example, on the text file
On the table
How can I import from the text file onto a table without reorganizing the data. I really need the data on this table to be in the same line sequence as the text file. I also tried commit every 1 record.
Thanks. I really appreciate your help and advise.