HardcoreTechnoHead
Technical User
Does anyone have a way of handling files that are larger than 2Gb with VB.
I have a Parsing Utility which has been used to parse text files (about 1Gb each) output from a mainframe billing system and insert the data into a database.
We are in the process of decomissioning the mainframe that produced the original text files and all of the original systems data has been dumped into text files for data warehousing.
The problem I face is that I now have 14x 90Gb files to parse. The utility will not read the file. I can open the file and get a handle to it, but any attempt to read produces and error 52 : Bad File Name or Number error
Dim lngFileHandle as long
Dim strReadBuffer as String * mc_lngRecordLength
lngFileHandle = Freefile
Open filename for Random Access Read Lock Read Write as lngFileHandle Len = mc_lngRecordLength
'fails here
Get #lngFileNumber, RecordNumber, strReadBuffer
I have tried opening for Input, Random and Binary and get the same results with each. Any Ideas
I have a Parsing Utility which has been used to parse text files (about 1Gb each) output from a mainframe billing system and insert the data into a database.
We are in the process of decomissioning the mainframe that produced the original text files and all of the original systems data has been dumped into text files for data warehousing.
The problem I face is that I now have 14x 90Gb files to parse. The utility will not read the file. I can open the file and get a handle to it, but any attempt to read produces and error 52 : Bad File Name or Number error
Dim lngFileHandle as long
Dim strReadBuffer as String * mc_lngRecordLength
lngFileHandle = Freefile
Open filename for Random Access Read Lock Read Write as lngFileHandle Len = mc_lngRecordLength
'fails here
Get #lngFileNumber, RecordNumber, strReadBuffer
I have tried opening for Input, Random and Binary and get the same results with each. Any Ideas