Copying a table from multiple databases (1 Viewer)

[Shannon]

I have one main database and many secondary databases. These database are on different computers that are NOT connect by a network. I would like to have them send a table from their database via internet and have me upload the table into the main database. Making one big table that I can run reports off of. I don't know where to start with this. I have been reading all night. I thought maybe transfer database but that transfers the whole database not just the table. If I due transfer the complete database then I could link the tables, right. There has to be a simple way!Any help quickly would be much appreciate. My deadline in January 2nd. Thanks.

 

[raskew]

Shannon-

Take a look at the TransferText action in the help file. You could develop a function to create a text file from your table and then reconvert it to a table at the receiving end.

Also, search this forum for tips since it has been a frequent topic.

Bob