Re: Easily copy a record to a table

From: Val Mazur (group51a_at_hotmail.com)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 22:56:55 -0400

Hi,

Just using Stream will not do this. You have several options:
1. Just loop through the collection of the fields and prepare INSERT SQL
statement
2. You could use XML stream from the recordset to *switch* recordset from
one db to another one. I have an example how to do this. If you need it,
then let me know by email and I will send it to you. It is too big to post
it here 

-- 
Val Mazur
Microsoft MVP
<cc@zqwe.com> wrote in message 
news:41587e1f.82438375@news.dallas.sbcglobal.net...
> Scenario:
>
> I have identical tables in two separate access databases.  With ado I
> want to use sql to query a single record from one table in a database,
> and then with a few lines of code take that record and copy it to the
> other identical table in the other .mdb file without using an INSERT
> sql statement.
>
> I just want to plop the record/recordset object field values into the
> other table's fields very easily.
>
> I was thinking maybe an intermediary stream object would do this for
> me in some way?
>
> Any suggestions?
>
>
>