I want to add a huge song list that resides in a text file and put into a mysql database without having to retype my whole list. The text file is arranged like so:

Song Title Artist Song #

Is there any way to convert a text file to a database?

Furthermore I would like to sort by all 3 fields. Any suggestions?

this is the list online I am trying to convert.

Karaoke song list

I also have this list in an older Microsoft Access database on my computer if this helps.

Thaks in advance, Dale.

Create a blank MSAccess database.
In FILE> Get External Data > Import.
You can use "tab" as the delimiter.

Hope this helps.

1. Copy it to a word processor.
2. Replace anything between every row with tab
3. Load it into mysql db.
example : "load data local infile "/your-path-to/yourfile.txt" into table mytable"
Hope its helps...
_________________________________
free ebooks php | free ebooks mysql