I've been trying to figure this out on my own for two days and I give up at this point. I'm creating a web administration interface, and the user would like to be able to upload a CSV file, and have it post to the database.
I originally tried using the microsoft text driver, and that worked great. However, putting the CSV in an array to save the information and then open the access database didn't work, because the CSV is so huge, I'm getting out of memory errors when running the array... and of course the client isn't interested in my ideas of why they should change hosts.
Anyway, my problem is this. I need to find a way to add the records in a CSV file on the server (I've already got the uploading working) to the database, without using an array. I'm stumped :(
Thanks so much for any advice you can give in advance!
- Ann