System.OutOfMemoryException

[skipper]

Hello all
I'm trying to load a 21Mb .csv (33 fields) file into a table using the following lines

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.

Many thanks
skipper

 

[Erel]

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.

 

[skipper]

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...

Thanks
skipper

 

[mjcoon]

Anyway, I converted the csv into a sql table with an external program.

What program, please? (I am contemplating converting to SQL too.)

Mike.

 

[skipper]

I used SQLite Expert Professional, IMO very easy and simple to use.
Skipper

 

[mjcoon]

I used SQLite Expert Professional, IMO very easy and simple to use.

Thanks for that. I'll give the freeware version a go, at least...

Mike.

 

[skipper]

I can't remember, but it seems to me that the freeware version does not have the import/export functionalities...

Mimmo

 

[mjcoon]

I can't remember, but it seems to me that the freeware version does not have the import/export functionalities...

Ah, the "Feature comparison" chart supports that recollection, so maybe I will be de-installing pronto...

Mike.

 

[skipper]

Sorry Mike,
as I said, I can't remember, may be I'm wrong. I used the freeware version more o less one year ago, then I switched to the Pro...

Merry Christmas and Happy New Year to you!

Mimmo