I have a number of reports that have been captured to file with embedded unicode names (Chinese, Japanese) mixed with numbers and English that I would like to read into an Excel spreadsheets. I cannot get delimited files, so I'm stuck with the fixed format files.
I've been testing the following:
Open sFileName For Binary Access Read along with MidB
Using the File System Object
I will need to process large files line at a time, so I cannot read the whole file at once.
I've looked through Safari Online for books, but have not been able to find anything useful. I'd really like some books and/or blogs that would also compare the different tools available to process large flat files.