someone knows how to use the bcp utility??
i´m trying to import data from a .txt file, but it´s giving me this error:
[microsoft][odbc sql server driver]unable to open BCP host data - file.

someone can help me??please
urgent..

thanks for everything

i would try to use openrowset function instead. see books online for more information.

Hi Daniel!

Tell us how txt file was created and how do you insert? Tell us the command line you are using.
The error may be due to incorrect file path too. Or there may be case of improper row and column terminator which you provide with -r and -t switches.

For example -
------------------------------------------------------
bcp "db..employee" out "d:\txt.txt" -c -t"\t" -r"\n" -U"user_name" -P"password" -q
------------------------------------------------------
In this example, if you have Column terminator Tab as -t"\t" and Row terminator as "\n", then you have to 'BCP in' in the same manner. Something like this -
------------------------------------------------------
bcp "db..employee" in "d:\txt.txt" -c -t"\t" -r"\n" -U"user_name" -P"password" -q
------------------------------------------------------

So, open the file, take a look on format and also path of the file. I hope you must have got the point. If you still have same problem, try to configure ODBC also.

Reply if it works or not..

- Som Dutt

Also did you look at the file your trying to import? Is the data consistent? Same number of fields per line, etc. Sometimes people try to BCP files that don't meet the requirements of the BCP program. To find out if this is true many times I cut the file into pieces. Perhaps starting with just five rows or so of data.