insertion of large amount of data
hi,
currently, i'm doing a site using asp.net(c#) with M$ access(2002)... the server will have to accept a large text file of at least 600KB... this seems to create a problem for the Access... before i knew, the connection just time out and nothing gets updated... it seems like access is the problematic one, yet converting to sql is not an available option for me..
what is a prefered way of updating such a huge text file to access?
insertion of large amount of data
I have tried inserting beyond 60,000 rows into access and it works fine.
So, I am thinking may be you can open the text file in excel and save it as .csv file format. This should give you some flexibility in uploading upto ~~65000 rows into access at once.