Export a table, send and attach by Email, import to a database?

[Daniel]

Hello, I need to know how I can export a Table to an attachment of an E-Mail
and then add the table to a Database. We have an overseas employee that
collects data for us and we need these tables sent to us in an Access Table
Format.

Regards,

Daniel.

 

[PieterLinden via AccessMonster.com]

Hello, I need to know how I can export a Table to an attachment of an E-Mail
and then add the table to a Database. We have an overseas employee that
collects data for us and we need these tables sent to us in an Access Table
Format.

Regards,

Daniel.

1. get the data out of Access to some format that the other DB can read it.
Use TransferSpreadsheet or TransferText
(see Tony Toews's site for e-mailing... fairly trivial)
2. you would have to create the table in the other DB (maybe write VB to
execute a SQL statement to build it).
3. Run the import.