Import very large txt text file 101MB in MS Access
Posted on 2004-11-13
I have a very large file in text format (txt) 101 MB that I can open in Notepad after 5 min
I need to import it in MS Access.
Uusing the import wizard function after 25/30 min the system says "the first row is too large". However I can not cut the first row in notepad
I tried twice, error message was the same
When trying to import this file in MS Excel using the import function, the system says "No memory" after 5/15 min
I tried to cut the notepad in half.. very long and tedious and the part I could open was not a proper representation of this section in notepad
Any advice to handle this case?