I have a csv file, which is over 1GB and I need to edit one column. Its impossible to open it in excel, so I used MS access...Via the external sources I have opened the file, everything seems correct, until I try to edit that one column. When I select the column I want to edit, click on replace, select what should find and with what to replace with and then select "replace all", I get the error message:
"The query cannot be completed. Either the size of the query result is larger than the maximum size of database, or there is not enough temporary storage space on the disk to store the query result".
How should I replace the column I wanna edit? I just want to replace value 200 to 201...
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…