Insert Into IN [message #20206] |
Mon, 06 May 2002 23:27 |
Alexis V.
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
Hallo!
I just wan't to send complete tables from one database into IN another ! heres an Example :Private Sub cmdtransfer_Click()
Dim lRecordsaffected As Long, lConnectstring$ lConnectstring = "cnnOracle.provider=MSDAORA;DSN=matchbox;UID=test;PWD=mis"
dbConn.Execute "INSERT INTO ST_CUSTOMER IN 'd:test.mdb'" + _
"SELECT * from ST_CUSTOMER ", lRecordsaffected
' dbConn.ConnectionString = lConnectstring
' dbConn.Execute "SELECT * from ST_COSTUMER IN S:ProjectsFraport_MATCHBOXDatenbankoraclemb.mb" + _
' "INSERT INTO ST_CUSTOMER IN d:test.mdb"
' "INSERT INTO ST_CUSTOMER IN C:DATENKLIENTEN.MDB" + _
'"SELECT ST_COSTUMER
'From ST_COSTUMER
'dbConn.Close
Debug.Print lRecordsaffected
End Sub
Are there any special's with oracle??
Please help !!
|
|
|
Re: Insert Into IN [message #20207 is a reply to message #20206] |
Tue, 07 May 2002 00:41 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
From what you say, I think you are trying to insert records into one database from another.
Assuming this is the case, you need to look at creating a database link between the two databases.
Once you have created a link, from database 1 to database 2, you can insert records across the linke (assuming that the user the link refers to has the required priviledges).
The syntax would be:
Insert into table_name@dblink_name.....
|
|
|