Non Csv Text File Import

[peterlaursen]

I think you will need to reforamt that file a little, using 'search and replace' in an editor, a 'macro' in some advanced editor or a script. If you need to do this at intervals you should find a way to 'automate' it!

You will need the same delimiter between data and another between lines/rows!

CSV/text import with SQLyog can be done 2 ways:

1)

Importing the file to an existing table (structure must be defined in advance):

http://webyog.com/faq/28_73_en.html

2)

Migrating with the Migration Tool and the text-ODBC driver. This will also create the table structure if you wish

[Author]

Posts