(Performance Issue) Inserting records in Access Database using VB 
Author Message
 (Performance Issue) Inserting records in Access Database using VB

What is the faster way of inserting records into an Access database (MS
Access 2000) using VB.
Right now I am using a disconnected recordset and inserting into another
access database, by firing INSERT SQL statement.
So in short I populate a disconneted recordset from a table from Master.mdb
and want to insert the whole table into Slave.mdb. Right now for doing this
I am using INSERT SQL to do this using ADO connection object and ADO
recordset.
Is there a faster way of doing this task.
If anyone knows please do let me know, it will be highly appreciated.

Abhi



Mon, 20 Oct 2003 01:08:13 GMT
 (Performance Issue) Inserting records in Access Database using VB

Take a look at

"INSERT INTO TestCities IN 'D:\Temp\Database.mdb SELECT City, State,
Latitude, Longitude FROM Cities"

"SELECT * FROM Cities INTO OUTFILE 'D:\Temp\Database.mdb'"

"INSERT INTO TestCities SELECT * FROM Cities IN... "

If both tables are in the same database just use

"INSERT INTO TableA SELECT * FROM TableB"



Mon, 20 Oct 2003 02:19:49 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How: Inserting and Deleting Records from Oracle 8i Database using VB's Execute method

2. VB Script error when Inserting records via ADO w/Access Database

3. Performance issue in inserting records

4. Performance issues in 6.5 when inserting a record

5. LAN Traffic issues between using VB Frontend/MS Access Backend vs Just MS Access

6. INSERT into access database using vb.net/ado.net..problem

7. Strange Performance Issue using ADO and VB

8. VB/ADO/MSSQL: Poor performance inserting records

9. Performance issue - Access 2000 using VB6 and ADO 2.1 with SQL

10. Very slow performance inserting records using CRecordset

11. Generating Schema compliant XML from SQL Server Database using SQLXML and XML Explicit -- [Performance/Maintenance issues]

12. How to insert record with OLE field using VB


 
Powered by phpBB® Forum Software