Easy way to export table data to be re-imported into identical DB?

[kyster]

Hi everyone!
I need to find a way to export particular data from a table, to be sent to our other offices in other cities so that they can import it into their database (Which is identical to the one I have)

So that we all have the same data after I have entered it. The transport method will have to be email, as our offices are in diferent cities.

What is the the most easiest, idiot proof, a monkey could do it, kind of way?


At the moment I can copy and paste the data out of the table into excel, send the excel worksheet. They then open the excel sheet, copy and paste the data into their access table. This method is long and prone to human error though! Any suggestions?

 

[Hayley Baxter]

You can do this programmatically or seeing as you have posted this in the macros section. Use the transferspreadsheet option to export the data from your table to excel then have another macro to send the excel spreadsheet to relevant email addressed. You could schedule this macro to run at a time suited to yourself.

Hay

 

[kyster]

Thanks Hay, I'll look into that. I only posted in the macro section because I didn't really know where to put this question because I have NO idea how to do it!