csv file import

Question

hi am saroj i need some help 

 

i want to import csv file into mysql database table.

where csv file header and table column header order are not match. i give examaple

 

suppose my csv file header are like

 

1.name

2.ph_no

3.address 

 

and my table column header are like

1.address

2.name

3.ph_no

4.postal_code

in that case how to import the csv file data into mysql database table

using upload button in asp.net???????

 

please help me i am fresher in that field

thanks in advance