Jul 24, 2008 12:18 PM|Robert1980|LINK
So I've got a big Access table that I need to run through to create a text file, one line for each row.
Now i'm getting an out of memory exception when filling the data table. I don't really NEED it all loaded in memory but i'm not having much luck with the OleDbDataReader.
What i would really like to be able to do is loop on each row in the results set from that select without loading the whole thing into a data table but i would be fine just killing the out of memory exception. (I'm garbage collecting right before and after
the code listed below)
I'm trying to duplicate the export to text functionality of Access but without using the access object. (Microsoft says that automating server processing using office controls is a bad idea)
Up to now i've just been doing this