Scott,
If you use Samba/iX (it's free) then:
1) Your users can SAVE their Excel files (in Text or CSV format) directly to
the HP3000.
2) You then process the files and send a Windows popup message telling them
the file is ready.
3) Your users IMPORT the data directly from the HP3000 into Access.
Simple hey!!
regards,
Robert
-----Original Message-----
From: Art Bahrs [mailto:[log in to unmask]]
Sent: 13 September 2001 16:21
To: [log in to unmask]
Subject: Re: Need suggestions for importing/exporting data or
Programmer's duc t tape
Hi Scott :)
Have you got SuprTool? This would allow you to create comma delimitted
files that can be easily imported into any of the xBase family of DBMS's
(Access is the latest cousin in this family) The comma delimited file
format also works great for going into Excel...
Art "hmmm... remember" Bahrs
----- Original Message -----
From: "Scott Gates" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, September 13, 2001 8:00 AM
Subject: [HP3000-L] Need suggestions for importing/exporting data or
Programmer's duc t 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:[log in to unmask]]
> -----------------------------------
> 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.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
