SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

  2. #2
    SitePoint Wizard
    Join Date
    Oct 2005
    Posts
    1,836
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)
    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: \t 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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •