the problem is that the file treats the whole content as one line, each line is represented as chr(10) in ascii (FYI,this file is extracted from a solaris machine). there are 2 file sizes. the first one can be read although it does not extract all the information where i can use the idea of breaking each chr(10) into a vbcrlf then adding it to the table one by one. the other one might be a problem because the file size is too large for the application to open.
I would like to use the FSO approach to open the file first but then again, i do not know how to define FSO so that it will create a file object for the large size file.
if you guys have any workarounds for this , really appreciate sharing it. thank you for all your time.