uploading tab delimited file to MySQL database

[eluser]agubski[/eluser]
Hi everyone,

Does anyone has experience uploading tab delimited text file to MySQL database. Either via PHP or PHPMyAdmin utility. Formatting the file to please PHPMyAdmin is too time consuming to properly deliniate all fields etc...

Thanks

Alex

[eluser]TheFuzzy0ne[/eluser]
You should be able to export an existing table as a CSV file. From that, you should be able to see the format required.

[eluser]agubski[/eluser]
Do you know if header line must be present in the csv file in order for it to upload properly? I have it working, but can't get consistent result. Each time there are strage fields appear. It also fails to replace the content of the table and each time seams to ammend it...

thanks for feedback

Alex