Hello all
I'm trying to load a 21Mb .csv (33 fields) file into a table using the following lines
B4X:
Sub Globals
'Declare the global variables here.
xSrcPath = AppPath & "\Source"
End Sub
Sub App_Start
Form1.Show
End Sub
Sub Button1_Click
tblTemp.Clear
tblTemp.LoadCSV(xSrcPath & "\" & "hugefile.csv", ";", True,True)
End Sub
The .csv loading stops with the "System.OutOfMemoryException" error. The strange thing is that sometimes the program loads the full table, other times it stops at different record....
Is there any memory limitation on table component? Any suggestion is welcome.
There is no specific limit to table control. However there are limits related to any process.
You should convert your csv file to a SQL table. It will be much faster and more reliable.
Hello Erel
that was exactly what I was trying to do ... the subsequent command should have been con.CreateSQLTable(...)
Anyway, I converted the csv into a sql table with an external program...