On Thu, 2015-06-04 at 16:01 -0700, James H. H. Lampert wrote:
Question:
How would you go about exporting records from a database file into
something a spreadsheet could deal with?
I'm not sure if someone has suggested it, but how about attacking the
problem from the other direction...
Within Excel use the ADO (assuming there is an i provider), create a
connection, and SQL the records required into Excel.
I have no idea how secure, quick, efficient (data set/where the sql
"runs"), complex (need some ADO and SQL experience) or automated this
can be, but it seems that if the set up within excel was done correctly
most of it could be automated to either get the most current data on
execution (so no requirement to make sure some job on the i has run) or
to get specific data sets as selected, on button press, or some similar
method.
There is also a slight advantage in that once its been proven and if it
works well any future (new) work or enhancements could be given over to
people who know and understand Excel. A disadvantage is that within a
short space of time every single user of excel will create their own
modified, or new, version on hundreds of individual pc's then start
screaming when their own unique version doesn't work or gets "lost" some
how (disk crash or just "I can't remember what I called it, its on the
disk somewhere, can you find it?).
--
JHHL
midrange.com
