Monday, March 19, 2012

Can MSSQL load a tab delimited text file?

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.BULK INSERT|||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.|||<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> 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.

I'm not sure what you don't like about his answer. Did you even bother to
look up the command he gave you?
|||Don't you have Books Online available? I expect Q. John Chen assumed you
would lookup the command:
http://msdn.microsoft.com/library/d...asp?frame=true

--
David Portas
SQL Server MVP
--

<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> 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.|||Oh...

So Bulk Insert is the command...

Thank you all...

No comments:

Post a Comment