ADO - Copy Data from one data source to another via VB6

From: rmsterling (rmsterling_at_avaya.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 07:35:02 -0700

Re: ADO - Copy Data from one data source to another via VB6

I have two data sources located on two different servers.
Both data sources are defined as a System DSN in the ODBC Administrator.

Currently I open both sources using ADO and copy the records from one source
to another. As there are thousands of records it takes hours to copy the data.

I noticed if both sources are SQL Server I can use DTS services. The problem
with this is that the SQL query is fixed. I need to be able to alter it from
VB6.

Does anyone have any VB6 code that does this using a OLE plug-in?
OR
Does anyone know any other way of performing this task quicker than the way
I am doing it above?

Please post answers to MSDN Newsgroup thread and to my email address below.

Many thanks in advance. 

-- 
----------------------------
Regards,
Richard Sterling 
Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815 
Avaya ECS Ltd, United Kingdom 
mailto:rmsterling@avaya.com

Relevant Pages

  • Re: ADO - Copy Data from one data source to another via VB6
    ... you can write BCP or DTS routines using SQL-DMO from VB6. ... ADO - Copy Data from one data source to another via VB6 ... > Both data sources are defined as a System DSN in the ODBC Administrator. ...
    (microsoft.public.data.ado)
  • Re: Connecting to external data source
    ... How exactly are you trying to connect to external data sources? ... I have tried various methods of connecting to Access databases, ...
    (microsoft.public.sqlserver.connect)
  • Re: Mailmerge in word 2007 of excel2007 file >256 columns (in fact
    ... Not using mailmerge. ... You may be able to get the data out using ADO, but it may not be able to "see" anything beyond column 255/256, even named ranges that start at column 201 and end at column 400. ... However, the focus in 2007 was clearly on the user interface, the XML file formats, and as far as working with "data sources" is concerned, on Content controls - I suspect the "approved" way to do this kind of thing would now consist of a bunch of .NET code to transform your Excel worksheet's data, stuff it into the appropriate data portion of a WOrd XML file, open the WOrd document and let Word fill the content controls from that XML data. ... "Peter Jamieson" wrote: ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... ability to interact easily with other data sources, and as far as I can ... In a basic app, IS there REALLY any ... it simple, if you need to support multiple dataasources from one code base, ... ADO is the only way to go. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADODB reference?
    ... The "A" in DAO *is* Access, and it's been there since version 1. ... When MS released Access 2000, they made ADO the default instead of DAO, and released articles implying that DAO was obsolete and ADO was the future. ... Consequently most of us stayed with DAO, and Microsoft put the DAO reference back in by default in A2003. ... to a variety of data sources but not designed specifically for Access. ...
    (microsoft.public.access.modulesdaovba)