Tab delimited text file import into PHPMyAdmin

Hi,

Is it possible to import a tab delimited text file into PHPMyAdmin? I know you can import CSV files.

Would I need to convert the text file to CSV?

Thanks,

Matt.

I’ve never imported tab-delimited text, but I understand that it can be done.

In the Import screen in phpMyAdmin, select CSV under Format. Under the “Format-Specific Options:” that appears, in the “Columns Separated With” box try entering a backslash and a “t” character like this: \ to indicate a tab character.

If you are importing data to a table that already contains data, it may be a good idea to make a backup of the existing table first.