Hi, I’ve got a client who uses remote front-end data collection devices. Historically, these devices have uploaded Access database files to a central server over the phone line. We now want to connect these devices to Navision. What is the best vs easiest vs least expensive way to have Navision automatically pick up and process data received via modem and/or internet? waynewil
. . .This is admitedly opinated but my suggestion is to use the SQL Server option and then on the open end post to SQL Server via ASP3/ASP.NET for your updates that are external.[8D]
If you have the files internet accessible, just use FTP. You can call a simple shell script to down load the file to the local drive, then import them.