Import a Text File

Vikas Mishra

14y1.8kSQL

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..........

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Accepted 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 Mishra14y ago
Thanks..........
Sam Hobbs14y ago
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.