MS SQL Server, loading data into a table from an external data source

loading data into a table from an external data source

Author	Message
Martin Fuch #1 / 3	loading data into a table from an external data source Hi, I'm fairly new to SQL Server and I need a little help on how to load data into an existing table. (Does anybody know Informix' "load-" and "unload-commands"? I'm looking for a synonym!). as a simple question: is there any way to transfer data from an ascii-file into a sql-server table? thanks for your help martin
Fri, 20 Oct 2000 03:00:00 GMT

Krishna #2 / 3	loading data into a table from an external data source Martin, Look at BCP in the Books-On-Line HTH Krishnan
Fri, 20 Oct 2000 03:00:00 GMT

Gianluca Hot #3 / 3	loading data into a table from an external data source Quote: > Hi, > I'm fairly new to SQL Server and I need a little help on how to load data > into an existing table. (Does anybody know Informix' "load-" and > "unload-commands"? I'm looking for a synonym!). > as a simple question: is there any way to transfer data from an ascii-file > into a sql-server table? Martin, have a look at the BCP command line utility in SQL Server Books Online documentation. Best regards, -- Gianluca Hotz __ Tecnical Service Manager at Alphasys srl / \/ / Microsoft MCP (Windows) MVP (SQL Server) / /\/ / Currently working for Ekar spa \ \/ /\ http://ghotz.home.ml.org \__/\ \
Fri, 20 Oct 2000 03:00:00 GMT

Page 1 of 1

[ 3 post ]