i making a program where I would read data from text files and store them in tables in myslq.
In my program I would create the table with the fields and in these fields I would insert the values from the text file.
My issue is that i don't know how! I would explain you why! In my program I would create table with fields (ID, Name). The values of these fields must be taken from the text file. The form of the text file is the below:

As you can see the ID is in the third row of the file and the Name is in the fifth. Could anyone help me how can I import the values for ID and Name in the table?How can i get these values?

Recommended Answers

Try using a csv file Click Here.

Jump to Post

All 2 Replies

Also you can use StringBuffer class to read data from txt file and then save it into database.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.