Exporting, Emaling and importing tables in Access

[KingKen]

I have a database that my users populate over a wide area. this database is not networked as it is not possible to do so given finance and location of users. I however want to have all the information in one data repository. To achieve this I am attempting to have a table of updated data exported, emailed central office, then imported to the main database and appended to the existing records. I want to accomplish the export and email function with just one click of a button then have the import function executed with one click also.

Has any one have had to perform this task befor or have insights on how to go about accomplishing these goals.

Thanks for the help as always.

[NeoPa]

What I did in a similar situation was to create a BackEnd database that the FrontEnds in all places link to. The remote station does their stuff then emails (a copy of the BackEnd to the central station where it is put in a specific place, where the cenntral FrontEnd can access it. Emailing in code is a whole nother thing entirely of course.

[ADezii]

I have a database that my users populate over a wide area. this database is not networked as it is not possible to do so given finance and location of users. I however want to have all the information in one data repository. To achieve this I am attempting to have a table of updated data exported, emailed central office, then imported to the main database and appended to the existing records. I want to accomplish the export and email function with just one click of a button then have the import function executed with one click also.

Has any one have had to perform this task befor or have insights on how to go about accomplishing these goals.

Thanks for the help as always.

You may want to look into Database Replication, but I warn you that it definately is not for the faint of heart!

[KingKen]

Ok guys you have done a great job at scaring me... Now how do we move forward? Where can I find info on Database Replication? how about exporting the data to a spread sheet then emailing that as an attachment then importing it and appending the data to the table.

[ADezii]

Ok guys you have done a great job at scaring me... Now how do we move forward? Where can I find info on Database Replication? how about exporting the data to a spread sheet then emailing that as an attachment then importing it and appending the data to the table.

I don't know your specific Access Version, so simply do a search on Access Database Replication, and you'll have more references than you can handle.

[NeoPa]

How about exporting the data to a spread sheet then emailing that as an attachment then importing it and appending the data to the table.

That could work, but I'd advise a text format rather than Excel if that's how you're minded. Excel is inherently dodgy for that purpose as it loses the type of much of the data.