Selecting data from a database, building StringBuilder. Trying to write a file using StreamWriter.
Using objWriter As New StreamWriter(strScriptNameMulti, False)
Get error: Exception of type 'System.OutOfMemoryException' was thrown.
Debug.Print result: sbInsertStatement.Length = 95567264
I can split it into two files. One ends up being 60 MB and the other is 32 MB. But I'd rather have one file.
Is there a limit to StreamWriter size?