Non Csv Text File Import

[kokko]

I have gotten a task assigned to me that I am pretty clueless to how I will finish it right now. I've got a txt file with data that I want to make import into a database. The data is in a certain format. Here is an example(Every number should be a field in the database):

Here's the whole txt file(the 6/4 GHz one): http://www.itu.int/ITU-R/space/plans/ap30b/index.html

I believe I have to use LOAD DATA INFILE but I'm not sure how to make mysql understand the data in the way it's formatted.

[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