LOAD SQL Table from flat file

Question

I am am trying to load a SQL table from a flat file. The flat i am talking about is a comma separated file. This has all the data required to populate a table will each column separated by a comma ",". I need some way by which i can load this content into the table faster.

Answer 1

If you are using SQL Server, use BULK INSERT

If you are using Oracle, see my answer here

Answer 2

Regardless of what database management system you are using, you could use a scripting language (such as perl or php) to set up a connection to your database, parse the file, and then insert the data into your database. Of course, you would have to know a scripting language...