Emport Text file Error

[Eeshan]

Hi,


Please help me to solve this error,

while importing text file m getting error as mentioned below picture..



i didnt get any solution and why it happens.....




Thanks & Regards,
Eeshan Singh

[rpeare]

You're importing an excel file, one of the fields in that text file is related to a primary key field or a field that does not allow duplicates in your table. in other words let's say you have:

1/1/2013,CompanyA
1/1/2013,CompanyB

in your text file and the date fields is listed as a primary key, or does not allow duplicates, your file will error out because you have more than one record with the same value in that field.

Look at the table you're importing too and see which field(s) contain your primary key then look at your text file and see if that field is properly set up.

[Eeshan]

Thank you for your support.

Suppose i want to import text file which fields includes duplicate. will it import succussfully ....?

If No, then why....? i want to import that text file.

data as per the below format

1/1/2013,CompanyA
1/1/2013,CompanyB
2/1/2013,CompanyA
4/1/2013,CompanyB
5/1/2013,CompanyB

m eagerly waiting for this ans..

Regards,
Eeshan Singh

[rpeare]

If you want to import a text file that has duplicates you have to modify the design of your target table.

If you have a primary key in your target table, remove it
If you have a field that does NOT allow duplicates, change it so that it will

I don't know the design of your target table but that's the problem with your import. Primary keys are the first thing to look for though because typically people do not mess around with the allow duplicates setting.