Comments by leejoyprakash (Top 4 by date)

Thank you Mehdi Gholam for your answer. This is really a useful piece of information.

Sorry that I forget to explain about my CSV file structure, in my case, the contents of one CSV file doesn't belongs to one table.
The CSV file is as follows:

COL 1,CAT 1,CAT 2,CAT 3,CAT 4,ITEM,DESCRIPTION
Val 1,Val 2,Val 3,Val 4,Val 5,Val 6,Val 7

The requirements are as follows:

1. COL 1 belongs to table1. First I need to check whether it exists, if not skip the record by tracking this in Error.csv
2. CAT 1 to CAT 4 belongs to table2. Check whether each of this exists, if not import into table2.
3. Item & Description belongs to table3. Check if exists, if not import into table3.

So I assume that, it not possible to do a bulk import for a CSV with values belonging to more than one table. Please correct me if I am wrong.

Thanks once again for your answer which really was a new idea for me.

Thanks