Need suggestions for importing/exporting data or Programmer's duct tape

[Glenn A. Mitchell]

One tool which I've recently begun to become familiar with that could be of
some help is Microsoft's Data Transformation Service (DTS).  It is provided
as a part of the MSDE/SQL Server environment which comes with Visual Studio
(Visual C++, Visual Basic, etc) and with Microsoft Office Developer's Kit.
While at first glance it appears to apply to SQL Server databases, it can
literally be used to copy and/or transform data to and from (almost) any
source: flat files, SQL, ODBC sources, etc.  There is a wizard that will
construct a wide variety of transformations and allows for plugging in VB
code or other scripting code to manage data selection/transformation.

I would guess that theoretically, if you have Samba running on the e3000,
you can use DTS to get the data from the PC to the HP and get it back from
the HP into your Access database.  You can probably also have it submit the
HP job to do the HP side of the processing by using FTP.

Glenn A. Mitchell  Mailto:g.mitchell@computer.org
3GM Associates, Inc
Portland, ME  04102
207-772-9370

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Scott Gates
Sent: Thursday, September 13, 2001 11:00 AM
To: 'Powerh-L (E-mail); HP3000-L (E-mail)
Subject: Need suggestions for importing/exporting data or Programmer's
duct tape


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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.