Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic file, data only once to summary? | Excel Discussion (Misc queries) | |||
Visual Basic File selection | Excel Programming | |||
creating an exe file with visual basic (installation file for Macros and Userforms) | Excel Programming | |||
How to Open A File with Visual Basic | Excel Programming | |||
Converting text to pdf file using Visual Basic | Excel Programming |