array to access
Thanks for the suggestion, but the output needs spreadsheet-like
capabilities such as sorting, formatting,
deleting columns, copy and paste etc.
I have sorted out the Access output and most users will have this as part of
Office, so I think this is kind of
done now.
I am still interested in the OWC spreadsheet control, but I can't find much
information about that.
RBS
"sali" wrote in message
...
"RB Smissaert" wrote in message
...
What I am trying to achieve is simply showing an array (a data table)
that
is too big for the sheet.
Probably it is best to make this an optional feature for people with
Access
or otherwise show it
as a text file. Will have a look into an Access viewer.
just as idea, don't know how rich viewer functions you need,
but if your data file has fixed line length maybe to use pure file i/o
functions
to read in a couple of lines of text file and show them,
also to have simple controls for basic navigation, scroll up-down.
for example, i made a sub (based on raw file i/o) for reading dbf file
much
larger than excel row count limit. this helps me to do the job without
having a need for any software except excel.
this comes from the old win3.1 days, but is still compatible!
|