I want to import a text file which delimited by tab to mysql.
1) using phpmyadmin => results ( exceed time limit even i've extend)
2) open using excel file save to .csv but still couldn't save all the record
3) using ms access with odbc connection => almost get all the data but not in sequence
4) using command => record is seems like not follow the real sequence which suppose to insert from top of the text file to bottom.
now i'm blur how how to get the detail correct in with the position. anyone please