| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load text file into memory for searching?
Check out the Open statement in the VBA Help: Their example of
Open "TESTFILE" For Binary Access Write As #1 However, if this is connected with your 1 ~ 5 million row text file, you will probably have to do it in chunks. NickHK "J@Y" wrote in message ... Is it possible to load a text file into memeory and perform binary searches to increase speed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for searching & copying Text from 1 text file to another | Excel Programming | |||
| load/parse large text file | Excel Programming | |||
| load a CSV file and have it take all fields as text | Excel Discussion (Misc queries) | |||
| Can I load text file into Excel seting field delimter using cmd li | Excel Discussion (Misc queries) | |||
| Load text file and write back | Excel Programming | |||
Threaded Mode
