Need suggestions for importing/exporting data or Programmer's duc
t tape
Scott Gates
SGates@olbh.com
Thu, 13 Sep 2001 11:00:10 -0400
I'm trying to automate a process that doesn't, so far, work well manually.
I have an Excel file, which I need to export to a flat file, move to HP, Put
into Quiz Subfiles, compare to TurboImage data, Get out a Quiz subfile (of
both the original subfile and now TurboImage data) , move back to desktop,
output to Access.
I'm pretty good with the PH parts and I can get to the 2nd subfile stage
pretty well, BUT, I need to automate the whole process so a USER can do it
on demand with little help from me.
I have the following tools Excel, Access, Powerhouse, MPEX. I have
Reflections, but cannot guarantee the user will, most of our users have
Minisoft. We also have FTP to and from the HP. I'm able to write simple
dos-type bat jobs. VB Scripts in Access and Excel would be a possibility,
but I've never written one.
I also have a grand total of $0.00 to spend in new software to simplify the
process.
Any suggestions are welcome.
Scott Gates
Programmer/Analyst
Information Services
Our Lady of Bellefonte Hospital
-----------------------------------
Phone: (606)833-3773
-----------------------------------
Primary e-mail : [mailto:sgates@olbh.com]
-----------------------------------
Confidentiality Notice: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail, fax or phone and destroy all copies of
the original message.