Hi guys, I am currently working on a Database for somebody.



The whole thing is that there are 2 databases, one is at the main computer and one is on the road. Lets say for example this was for a police car. They record tickets on their client side database, then once they are done for the day, they export the ticket data into a file then go to the main headquarters and import that same data into a large database containing all the records in the police department.

Which combination of import/exporting code is best for this situation? I want them to use vba because they are going to be using a program, so I wont be letting them use the Access File->Export kind of method thing.

Thank you,
Steve

Edit: I just said cuz, wow what am I 14 years old?