View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default 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


.