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
|