loading data into a table from an external data source 
Author Message
 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
 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
 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
 
 [ 3 post ] 

 Relevant Pages 

1. Loading External ODBC Data Source to Oracle Table via PL/SQL

2. DAO: problems attaching external tables (ODBC data sources)

3. Reset source of data for Data Report on Load

4. Data Source: Programmatically Configuring an ODBC Data Source - HELP PLEASE

5. cannot add MSAccess 97 data source in ODBC Data Source Admin

6. Help:ODBC Data Source Admin doesn't show Names of new Data Sources

7. Handeling Data while transforming data from a Source Text file to a Destination Database Table

8. Creating external data source files from within MFC or DAO

9. XDR (External Data Representation): Sources, references

10. Connecting to External Data Sources

11. HELP Importing data from an external ODBC Source

12. importing data from an external source


 
Powered by phpBB® Forum Software