|
|
Author |
Message |
D975XBX2Blue
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
|
|
|
|
|
|