Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic file, data only once to summary? NeedToKnow Excel Discussion (Misc queries) 2 November 11th 09 12:16 PM
Visual Basic File selection Heath Excel Programming 1 October 7th 04 04:38 PM
creating an exe file with visual basic (installation file for Macros and Userforms) [email protected] Excel Programming 3 August 5th 04 10:16 AM
How to Open A File with Visual Basic Lance[_3_] Excel Programming 1 November 18th 03 08:43 PM
Converting text to pdf file using Visual Basic nitin khabia Excel Programming 1 September 12th 03 02:10 AM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"