View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default basic file I/O

Gary,
I assume you mean "greater than 65K rows".

You can query the file, using DataImport External DataNew database query,
or ADO.
If you need/want to read the file yourself, look at the Open Statement in
VBA help.

NickHK

"gary" wrote in message
...
Using Crystal Reports, I am extracting information from a CITRIX db. The
query returns greater than 65 rows -- so I can'r return the results

directly
to EXCEL. I would like to save the result as a file, and read the result
using basic file I/O from within EXCEL: Open, read a row, process a row,

get
next row, EOF, Close.

Each row is csv with four fields: Text, number, number, text.

Could you please point me to some good documentation on this topic -- or
have a snippit of code?

Thanks, Regards,
Gary