Insert a table form one database into another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 30 Aug 2005 22:30 GMT

I have identical table structures in two databases, one on a client side and
the other on the server side. I want to run an asp query that will take all
of the records from the client and push them into the server db.

Is this a Insert command that I have to loop for each record, if so how?

I have seen Insert Select queries talked about in this forum, will this push
the data into a server db?

I need help getting started.

Thanks

Reply to this Message

John Vinson - 31 Aug 2005 00:56 GMT

>I have identical table structures in two databases, one on a client side and
>the other on the server side. I want to run an asp query that will take all
[quoted text clipped - 8 lines]
>
>Thanks

An APpend query will do the trick here:

INSERT INTO hosttable
SELECT ([field], [field], [field], ...)
FROM localtable;

John W. Vinson[MVP]

Reply to this Message

Dave - 31 Aug 2005 01:26 GMT

Can this be:

INSERT INTO hosttable
SELECT *
FROM localtable;

Do I need to reference the database name or is that handled by the recordset
connection?

Thanks

>>I have identical table structures in two databases, one on a client side
>>and
[quoted text clipped - 19 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 31 Aug 2005 20:04 GMT

>Can this be:
>
[quoted text clipped - 4 lines]
>Do I need to reference the database name or is that handled by the recordset
>connection?

Either way. If you've used ODBC or Tools... Get External Data... Link
to link to an external table, that linked table can be used in very
much the same way as a local table; or you can use the IN operator in
the SQL statement to dynamically link to a connected table.

John W. Vinson[MVP]

Reply to this Message