Insert Array into Database Table

[mharroff]

I am writing a script that runs a report on a mainframe and then does screen scrapes to collect data for inputting into an Access database.

Currently I am able to get the data from the screen scrapes into an array which I then write to my database one record at a time. This is much to slow as I am processing over 3000 records with 5 fields each everytime I run the script. It currently is taking about 30 minutes to complete and I need to reduce the to write the records to the database.

Is there a way that I can insert the entire array at one time into the database?

 

[PHV]

It currently is taking how many time to only get the data into the array ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mharroff]

It is hard to say. The script will log on to the server and run my report. I then do a screen scrape and collect my first 10 records, write those to the database (Have tried using both "RS.addnew" and "Insert Into" but didn't notice appreciable time savings either way), page down to the next screen, collect 10 more and so on and so forth.

I have about 300 screens to scrape but it appears that about 60 to 70 % of the time is occuring after the screen scrape and paging down to the next screen.

The best answer would be for the mainframe people to export the data for me but that involves three other teams and they don't want to apply the resources even though the savings by this project are estimated to be over $500K !!!

 

[PHV]

It is hard to say
Simply comment out the actual write to database code !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886