by VICTOR FRANCISCO CAJARITO - STI - PHIL. (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Unknown Difficulty
Originally Published: Fri 27th July 2001
Date Added: Mon 8th February 2021
Rating: 
(1 Votes)
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
VBcoders
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"
No comments have been posted about Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousan. Why not be the first to post a comment about Trasfering a whole table from SQL 6.5 Database Server to MSAccess 97 using ODBC connection. thousan.