• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousan

Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousan

Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousands of records transfer for 5 to 10 seconds.

API Declarations


Dim b As Recordset
Dim c As Connection
Dim d As Recordset




Rate Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousan

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Set a = New ADODB.Connection
    a.Open "DSN=DbaseName"
    Set b = New ADODB.Recordset
    b.Open "Select * from TableName", a, adOpenDynamic, adLockPessimistic 'Original Table to be transfer
    
    Set c = New ADODB.Connection
    c.Open "DSN=DB1" 'Table to be transfer
    Set d = New ADODB.Recordset
    d.Open "Select * from victor", a, adOpenDynamic, adLockPessimistic

    a.Execute "insert into db1.victor select * from TableName"