INSERT INTO IN ? [message #1468] |
Fri, 03 May 2002 03:50 |
Alex.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 #1476 is a reply to message #1468] |
Sun, 05 May 2002 21:05 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
If you want to write into oracle
I think you should write like this
INSERT INTO ST_CUSTOMER select * from KLIENTEN;
I dont know more about VB as you wrote for click event
|
|
|