Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Import from multiple txt files

forums › forums › SQLyog › Using SQLyog › Import from multiple txt files

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 26, 2003 at 3:00 am #14717
      CalEvans
      Member

      Pretty much you just can't do that. The import is basically a seriese of inserts, one for each record.

      YOur best bet is to use something like Excell to stitch the fields together into records, then save the final as a csv. Then try and import that.

      HTH,

      =C=

    • July 26, 2003 at 10:13 pm #14718
      syrinx
      Member

      Thanks for you reply Cal, but I found the solution. First, I switched to my Linux box (you know, there are more useful tools), then searched inside textutils package….and the command is

      $ paste -d , file1.txt file2.txt ….

      Regards.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.