BCP utility

I need some examples of using BCP utility directly from Dos prompt (SQL Server 7 on Win 98) and from VB.
Thank you.
Vlad

[Lothar Haensler]

why do you want to use BCP with SQL server 7, when there is DTS (data transformation services) in SQL server 7?
Did you look at that?

I'm new to SQL Server and I've just got a new job. My current company uses bcp in all business processes to create flat files which will be sent to our partners. Also I was told that this is the fastest method to transfer data. My goal now is to write some VB procedures with bcp to do those processes from application, not from DOS prompt.
Thank you.
Vlad

[Kailash Marthi]

You can use "bcp" with SQL Server 7 on Windows NT.
Isn't it packaged on Win 98 ? (Don't have SQL Server on Win 98 available).

I have SQL Server 7 on Win 98. I can run simplest BCP on this system. I have some problems with formatting the output (I do not have any samples which I could use to run and get good *.fmt file, file which is responsible for formatting the main file). Next, I would like to see any examples of using BCP from VB with Shell function or something else (I don't know is there any other ways to run BCP from VB).
Thank you.
Vlad

just reminding that I'm waiting for an advice.
Thank you.
Vlad

[Karina Gámez]

did u find something about bcp utility.... ?? from visual basic??

can u help me ...?