Add Mass Data To Database

So I have a question say if I wanted to add a bunch of text to a database, but in its own separate row how would I go about doing that.
Because its alot of text and I do not want to set up the basic insert query for like a 1000 things of text that need to go into there own rows

 

Create a script to import the text in multiple rows or use the database's imort mechanism.

 

well parse the data line by line and import it into the database

 

if its in .txt file just use bulk insert. thats the easiest way. If you are clear with bulk insert then just give me a sample text file and table definition i will right a query for you.

 

If the data is in tables, csv you can easily convert them in SQL and import in your database using phpmyadmin of cpanel.

 

You can simply use bulk insert command

 

which DB you using?