CSVFiletoarray reading large file

[jsmyong55]

I am experiencing a problem where MS hangs when I read a huge CSV file containing more than 10k records. What is another alternative to using csvfiletoarray?

I have to read all records from the csv and then transfer it to the database. Would DB query be a better option? Or Readln (and removing the delimiters of course)?

[Marcus Tettmar]

DBQuery or use the XL commands to read one cell at a time.

[Grovkillen]

I have a large CSV-file (almost 3MB big, 18 000 rows, 12 columns) and I have problems importing this as an array when compiled my script as a EXE-file.

Is there something I should know about the CSVFileToArray regarding limits?

[Marcus Tettmar]

What problems? Should be absolutely no difference between any script running as a .exe vs not.

[Grovkillen]

It crashes the program, i.e. "not responding". I have managed to get it to run the complete cycle once in maybe 10-15 tries...

[Grovkillen]

I just realized that I use semicolon ";" as delimiter instead of comma ","

Could this be the problem (even though I get it to work in the editor)?

[Grovkillen]

I found out that a DelArray> just prior to the CSVFileToArray> was causing the problem. I just removed the DelArray> and it worked just fine. Sorry for flagging this as an issue.