Load file

I am using MSSQL 2000, I also using mysql.
I want to know does mssql 2k had a command or function like mysql that (
load data infile.........) this synax???_ wrote:
> I am using MSSQL 2000, I also using mysql.
> I want to know does mssql 2k had a command or function like mysql
> that ( load data infile.........) this synax?
Look at the BCP utility in BOL. You can also script data out using the
Import Export Wizard.
David Gugick
Imceda Software
www.imceda.com|||Or the BULK INSERT command...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OyhifiasEHA.2720@.TK2MSFTNGP12.phx.gbl...
> ??_ wrote:
> Look at the BCP utility in BOL. You can also script data out using the
> Import Export Wizard.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>