Need to Send Data from Remote to Host

[jlkpal]

Hi,

We currently enter data on several PC’s using a LAN. Everything works fine. Now, we want to enter the data remotely and send the data to a “Host” PC. The remote users do not have Internet access, only a modem with whatever software will be necessary for the transfer, as well as MS Access, etc.

After the data has been transferred to the “Host”, Queries or Macros will need to be run to process the information. Then, additional data will need to be sent back to the “Remote” PC for further processing.

Which software can I use to transfer the data from the “Remote” to the “Host”?

Thanks in advance for your help…

 

[tonymce]

winbatch can do it provising you export the data first
use a macro to export the data to csv
the use winbatch or a bat file to transfer the file to the server via ftp or somthing then use a timed code on the server to listen to the folder and pick up anything in it if not emptyt then process it.
if you have multiple sites you can use different folders and the server app will listen to each folder and do the relevant action.

You can automate the export or just do it as a user click.
look at freevbcode.com you can get some vb code to do want you want their.
I would use vpn shared folders and an automated copy code

somthing like this
Dim fso As New FileSystemObject
fso.CopyFile "c:\mydocuments\letters\export.txt", "\\serverpath\folder\"

automate the export in a macro then call it after the call run the above code

hope this helps

 

[jlkpal]

Thanks so much for the valuable info…

Which program would be the best for file transfer? - WinBatch, pcAnywhere, HyperTerminal, or something else?

What is the name of the program with the timed code on the server where it would listen to the folder?

Thanks again…