Text file having Table data so i want to put this data in to data base in mysql serve

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • murlikrishna
    New Member
    • Jul 2012
    • 3

    Text file having Table data so i want to put this data in to data base in mysql serve

    in my data.txt file having data that is to be inserted in the data base.

    i my data.txt file if having more than one row of data then how to do that.

    does there is any functions to do that easily?

    reading the data there after splitting it then inserting is complex .does there is any other way?
    Attached Files
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    First you need to open the Text File.

    Then you need to read each line into your program.

    When you have a line you need to do the necessary process to retrieve the information from the line and store it into the database.

    Here's an article about how to read from a text file.

    Here's an article about how to use a database in your program

    -Frinny

    Comment

    Working...