By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,550 Members | 918 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,550 IT Pros & Developers. It's quick & easy.

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

P: 3
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
File Type: txt data.txt (93 Bytes, 208 views)
Jul 29 '12 #1
Share this Question
Share on Google+
1 Reply


Frinavale
Expert Mod 5K+
P: 9,731
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
Aug 2 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.