• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3561
  • Last Modified:

How to convert Folio Bound Views .nfo file to mysql database?

I have a file which is about 100MB in size.  It is a Folio Bound Views .nfo file.  Folio Bound Views is a legacy software which was used about 7-8 years ago for accessing and reading large databases.  The .nfo file is a flat database text file with numbers and letters as delimiters for each record.  

If you are not familiar with this type of file you might be able to find more information here:


The folio software line was purchased by NextPage in 1999, they no longer support folio but offer a migration tool for people to upgrade their old .nfo files.

What I want to do is get all the info in the flat database file (the .nfo file) into a mysql database.

Anyone know how to do this?
1 Solution
Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html.

I think it's flexible enough to handle what you're doing, although I'm not familiar with folio.

sudamaAuthor Commented:
Hmm, I had a look at that it should work but I'm not sure if the delimiters in my files are set up correctly.  Anyway here's the 300 pts for ya.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now