Can MSSQL load a tab delimited text file?

[joealey2003@yahoo.com]

Hi all...


I would like to know if SQL SERVER can load a tab delimited text file.

If yes, how?

A search on the web did not return me the "load data" command as mysql
or other.



Thank you all.

[Q. John Chen]

Re: Can MSSQL load a tab delimited text file?

BULK INSERT

[joealey2003@yahoo.com]

Re: Can MSSQL load a tab delimited text file?

Oh my god...

Why you say it is a bulk insert man???? Come on....

I am a MySQL user and wants to know if i can load my data on MSSQL
without a need of a converter.

[Greg D. Moore \(Strider\)]

Re: Can MSSQL load a tab delimited text file?


<joealey2003@ya hoo.com> wrote in message
news:1117271736 .412801.299580@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> Oh my god...
>
> Why you say it is a bulk insert man???? Come on....
>
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.[/color]

I'm not sure what you don't like about his answer. Did you even bother to
look up the command he gave you?

[color=blue]
>[/color]

[David Portas]

Re: Can MSSQL load a tab delimited text file?

Don't you have Books Online available? I expect Q. John Chen assumed you
would lookup the command:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp?frame=true

--
David Portas
SQL Server MVP
--

<joealey2003@ya hoo.com> wrote in message
news:1117271736 .412801.299580@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> Oh my god...
>
> Why you say it is a bulk insert man???? Come on....
>
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.
>[/color]

[joealey2003@yahoo.com]

Re: Can MSSQL load a tab delimited text file?


Oh...

So Bulk Insert is the command...

Thank you all...