data load problem

[#1]

Hi All,

I'm trying to load a csv file which is having 95,000+ rows. Loading is successful but all the rows are not getting loaded. So could you please suggest some option to load entire data.

Thnaks!!!

[hic]

Why do you think that all data isn't loaded? What's the symptom of the problem?

HIC

[its_anandrjs]

You can cross check that your file is loaded completely or not by using

TableName:

Load * From CsvLocation;

Let vNoFields = NoOfFields('TableName');

[#4]

I'm not able to see few rows in edit script preview. And I'm not able to see few records in list box.

[#5]

vNorows shows 33

[its_anandrjs]

Did you check you can use proper Delimiter Like Semicolon, Comma, Tab, Spaces

[its_anandrjs]

Check with your csv file there is 33 fields are same or not

Let vNoOfFields = NoOfFields('TableName');

and also Did you check you can use proper Delimiter Like Semicolon, Comma, Tab, Spaces

[hic]

How many rows do you see?

If you mark a list box, you will get some numbers to the right of the status bar (bottom right).

These show some interesting things:

The "D: 4/52" means that my selection has 4 distinct values possible of 52 in the field.

The "F: 146/772" means that there are 146 records possible of 772 loaded (in the table where the field in question exists).

So, which numbers do you have there?

HIC