|
|
Posted by Greg D. Moore \(Strider\) on 10/08/05 07:21
"Mike" <noway@forgetit.com> wrote in message
news:I%x1f.918$Si4.490@newssvr30.news.prodigy.com...
> Sorry my mistake, it is 150,000 to 200,000 lines.
>
> Where could I find information using BCP or BULK INSERT?
Books Online that comes with SQL Server.
For reference, I just imported 700,000+ records yesterday, with several text
fields in each.
Took less than 15 minutes.
Fortunately this was in native format and already sorted. But you get the
idea.
I used BULK INSERT.
>
> Mike Charney
>
> "SQL" <denis.gobo@gmail.com> wrote in message
> news:1128696326.936346.93820@o13g2000cwo.googlegroups.com...
> > 2000 lines is far from large but anyway use DTS, if the files get
> > bigger (50000 lines+) use BCP or BULK INSERT
> >
> >
> > http://sqlservercode.blogspot.com/
> >
>
>
Navigation:
[Reply to this message]
|