Re: Read from one, write into another data source

> Again, this sounds like you're using ADO to to transport (bulk copy) data.
> ADO is a query interface, not particularly suitable as a bulk copy engine.
> Use BCP or DTS for this.

A few things:

1. Can BCP or DTS be used programmatically Bill?
2. Are BCP/ DTS available for databases's and can be used other than with
SQL Server 2000 and successors?

If the answer to both questions is not "yes" - then that is why as
(i) ADO can be used programmatically
(ii) and with the right ODBC driver or OLE DB provider, ADO can be used for
all databases
which is the attraction for using ADO to copy despite its performance
limitations

Cheers

Stephen Howe


.

Relevant Pages

  • Re: Using Excel data in a VB6 database
    ... I am talking about a bulk insert of text comma delimited records into a table. ... the comma-delimited data into a database table that has the fields already set-up in the table. ... You load the table with the database utility to load text comma-delimited data into the table. ... Or you write a VB 6 program using a text reader, read the text file and use ADO to insert the records into the table, after you have populated each field in the table from the comma-delimited record you just read. ...
    (comp.programming)
  • Re: Bulk Inserts - High Speed
    ... ADO client will use a lot of memory as you've discovered. ... You can use BULK ... > commands SQLServer seems to bog down and get really slow. ...
    (microsoft.public.data.ado)
  • RE: ADO bulk insert and C++
    ... I am trying to use an ADO _ConnectionPtr to execute a bulk insert ... yields the error: -2147467259 (with the same statement and the same ... When I execute the statement through the query analyzer it allways works. ...
    (microsoft.public.sqlserver.programming)
  • Re: Execution Plan Hinting
    ... bulk insert field_values from '274.dat' with; ... ADO thing? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Bulk copy question
    ... I want to bulk copy data from a SQL server 2000 table to ... Can I use ADO to do the ... I need to copy the bulk data from the source table into a file on the ... disk and then push ...
    (microsoft.public.data.ado)