I have two nice questions in one here.
Having had a CVS dump sent to us (the only method possible), we have a large
19MB chunk to import into a table.
However, JET says it can't find the file. I can only attribute this to file
size.
If there any way to import this amount of data?
I am currently in the process of writting a small script to split the file
down into 10,000 line chunks, however, at over 1,220,000 records, it will be
rather detius to do the import.
Once imported, I will create a copy, and use queriy later to perform any
data changes, coz, I aint re-importing it.