I did finally get them to load and have successfully done up to 15,000 at a time for testing, but it does take a long time. I found out that my problem was with the entries that that had double quotes in them - usually for nicknames. Thanks for letting me know that you are doing so many at a time, because I will need to load about 28,000 or so when we do our final load. On 1:59 PM, David Schuster wrote:
Sorry I'm late reading this - but I'm loading 28,000 lines at a time(all of our secondary students) and about (20,000) lines at a time elementary students. All through the browser - it spins for a long time, but eventually get a report.
I'm actually working with a vendor to build a script to load these automatically every Monday from our student records system. It picks up a file using certain parameters and loads them using the .pl program.
David Schuster Plano ISD
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824