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 |
All times are GMT +1. The time now is 02:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com