One great thing about Access is that it can call the Windows API. And if
your users have Internet Explorer 3.01 or above on their PC's, they have
an API within the Wininet.dll (which comes with IE) that can do ftp (or
http).
Try this webpage for start:
http://www.mvps.org/access/modules/mdl0037.htm
Here is a simple example:
http://groups.google.com/groups?q=wininet.dll+ftp+group:*access*&hl=en&r
num=2&selm=814rnq%24ism%241%40nnrp1.deja.com
I've used the wininet.dll for years to do ftp from Access to VMS.
Bruce Schuck
> -----Original Message-----
> From: [log in to unmask]
[mailto:[log in to unmask]]
> On Behalf Of Scott Gates
> Sent: September 13, 2001 8: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:[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.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: [log in to unmask]
> Subscribe: "subscribe" in message body to
[log in to unmask]
> Unsubscribe: "unsubscribe" in message body to powerh-l-
> [log in to unmask]
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
subscriber.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
