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?
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.
This topic is now closed. New replies are no longer allowed.