Jun 21, 2002 #1 puredesi5 Programmer Sep 26, 2001 50 US Can I load just few columns (not all columns) from a text file to table using BCP?
Jun 21, 2002 #2 tlbroadbent MIS Mar 16, 2001 9,982 US Use a format file. How to do this is explained in "Using a Data File with More Fields" in SQL BOL. http://msdn.microsoft.com/library/en-us/adminsql/ad_impt_bcp_9y43.asp Terry L. Broadbent - DBA Computing Links: http://tlbroadbent.home.attbi.com/prog.htm faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions. Upvote 0 Downvote
Use a format file. How to do this is explained in "Using a Data File with More Fields" in SQL BOL. http://msdn.microsoft.com/library/en-us/adminsql/ad_impt_bcp_9y43.asp Terry L. Broadbent - DBA Computing Links: http://tlbroadbent.home.attbi.com/prog.htm faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.