Used the bcp facility
Gives a message
ODBC ... ISQL Server doesnot exists or access denied

The command I gave is below

bcp melinda.dbo.element out d:\temp\TableElement.txt -c -t, -T


Guess I have missed the ODBC connection. I have an ODBC connection present.
How do I connect this ODBC connection to the command

I have used BCP on SQL6.5

This is a copy of my command file,

bcp.exe Invoice..tblinvoice out :\file.out /fC:\bcp.fmt /usa /ppassword /sDB1-Server

Hope this helps

Ryan:D