| Author |
Can MSSQL load a tab delimited text file?
|
|
| joealey2003@yahoo.com 2005-05-28, 3:23 am |
|
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 2005-05-28, 3:23 am |
| BULK INSERT
| |
| joealey2003@yahoo.com 2005-05-28, 7:23 am |
| 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\) 2005-05-28, 7:23 am |
|
<joealey2003@yahoo.com> wrote in message
news:1117271736.412801.299580@f14g2000cwb.googlegroups.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?
>
| |
| David Portas 2005-05-28, 7:23 am |
| 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.googlegroups.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.
>
| |
| joealey2003@yahoo.com 2005-05-28, 8:23 pm |
|
Oh...
So Bulk Insert is the command...
Thank you all...
|
|
|
|