This is a general question on the best way to import a large amount of data
to a MS-SQL DB.

I can have the data in just about any format I need to, I just don't know
how to import the data. I some experience with SQL but not much.

There is about 1500 to 2000 lines of data. I am looking for the best way to
get this amount of data in on a monthly basis.

Any help is greatly thanked!!

Mike Charney

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/

Sorry my mistake, it is 150,000 to 200,000 lines.

Where could I find information using BCP or BULK INSERT?

Mike Charney

"SQL" <denis.gobo@gmail.com> wrote in message
news:1128696326.936346.93820@o13g2000cwo.googlegro ups.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/
>

In Books on line, do a search for bcp or BULK INSERT

http://sqlservercode.blogspot.com/

Using DTS is very good idea but there is a import/export wizard
(something like building dts wizard). It is very simply.

"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.googlegro ups.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/
> >
>
>