Thread: array to access
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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!