BradEdwards
Technical User
I have 24 facilities in which we download a journal.mdb every night. In the morning I run a program that I wrote in VB that consolidates all 24 journal.mdb files into one file. This creates one big journal.mdb file which has anywhere from 15-20,000 records in it. I added to my VB program a section which INSERTS those records into a database on our SQL Server for future calculations. However, it takes about 4-5 minutes to upload those 15-20,000 records into the SQL Database. Is this normal or is there a faster way to do this. I've used SQL Pass Through queries before which queries and deletes data quicker but when I tried to write a pass through query to insert data it said it couldn't find the source table which is local to Access. It's not that big of a deal. I just wanted to know if there was a faster way. In VB I set an strSQL variable to "Insert ......" then run db.execute strSQL.
One other question? If there is not a faster way, is there anyway I can add a progress bar or some sort of status box that displays the number of records transferred so far just so the user doesn't think the program is locked up. Any help would be much appreciated. Thanks.
One other question? If there is not a faster way, is there anyway I can add a progress bar or some sort of status box that displays the number of records transferred so far just so the user doesn't think the program is locked up. Any help would be much appreciated. Thanks.