Hi Helen,

The systems that will be uploading their data are on different pcs, on different networks, and possibly are in different countries than the master system that requires their data.

I was imagining scheduling all the systems to upload their data (a csv export) to the central system, via ftp or http or whatever, every night, and scheduling the central system to import all the data every morning, something like that.

I am using embedded firebird on both the central system and the uploading systems.

I have considered having the uploading systems upload a firebird database file containing only the new data that they need to pass, or uploading a CSV or some other export of the data.

My thinking at the moment is that the CSV of other sort of export is better, as it defines a cleaner interface for the data transmission, in case there is a future requirement for some other system to examine the uploaded data.

Thanks for the advice. Any suggestions appreciated.

Cheers
Sam