mass data load  
Author Message
D975XBX2Blue





PostPosted: Mon Nov 08 10:52:15 CST 2004 Top

SQL Server >> mass data load

In SQL 2000, how to load records (about 5,000 or so) from a tab delimited
input file to a table?

Thanks,

Bing

SQL Server42  
 
 
Adam





PostPosted: Mon Nov 08 10:52:15 CST 2004 Top

SQL Server >> mass data load Look up BULK INSERT in Books Online.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--




> In SQL 2000, how to load records (about 5,000 or so) from a tab delimited
> input file to a table?
>
> Thanks,
>
> Bing


 
 
mike





PostPosted: Mon Nov 08 10:53:03 CST 2004 Top

SQL Server >> mass data load Hi

In BOL, look up BCP and DTS.
2 simple technologies that come with SQL Server.

Regards
Mike



> In SQL 2000, how to load records (about 5,000 or so) from a tab delimited
> input file to a table?
>
> Thanks,
>
> Bing