ExcelBanter - csv file into vb.array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - csv file into vb.array (https://www.excelbanter.com/excel-programming/280363-csv-file-into-vbulletin-array.html)

Hasan Cansü[_2_]

csv file into vb.array

Hi all,

does anyone know any simple way to directly store the
values of csv file in a multidim array (without importing
it into excel)?

My csv file has for now appr. 500 col & 5000 rows, growing
each day. First col is a timestamp, others are market
prices in decimals.

Thanks
Hasan

Jan Karel Pieterse

csv file into vb.array

Hi,

You might try using ADO for that.

See this site for more details:

http://www.erlandsendata.no/english/...odao/index.htm

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Hi all,

does anyone know any simple way to directly store the
values of csv file in a multidim array (without importing
it into excel)?

My csv file has for now appr. 500 col & 5000 rows,
growing
each day. First col is a timestamp, others are market
prices in decimals.

Thanks
Hasan

.

All times are GMT +1. The time now is 09:52 AM.