Current location - Loan Platform Complete Network - Big data management - How to add more than 500,000 pieces of data to access in vb at one time to improve code efficiency. Please give me the code from an expert. 3Q
How to add more than 500,000 pieces of data to access in vb at one time to improve code efficiency. Please give me the code from an expert. 3Q
1. Open the connection 2. Add to the database sql in batches. Use insert into A values ??(1,2,3),(4,5,6),... to insert into access at one time 3. Close the connection and ask: Add with ADO