Import a Text File

Question

Hi Friends..... I want to attach a Text file into database then How do I import a text file of data into a database?is there any specific command for it? Thanks..........

Satyapriya Nayak · Answer

Hi Vikas Please refer the below link. http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/ Thanks

Vikas Mishra · Answer

Thanks..........

Sam Hobbs · Answer

It depends on what you mean by  attach a Text file . If you mean that you need to import a CSV file or a similar text file then there are many articles in this web site to help you. Also since you say command I am not sure you are asking about how to do it using programming so if you do not want to write a program then please make that more clear. If you instead need to put the entire contents of a text file into one field in a database table field then please make that more clear. The main thing about doing that is that you need to use a memo field in your database table.