Suppose an email contains a attachment that is a MS Access database.
The content of this database consists of only one datatable. Once the email is sent and received,I know how to retrieve the attachment as a whole from this email and put it in a folder on my harddisk. Therefore I use the command SaveAsFile e.g.
If olAtt.FileName = "Orders.accdb" Then
olAtt.SaveAsFile MyPath & olAtt.Filename
End If ' (olAtt is a attachment-)
After that i can with a "DoCmd.transferDatabase acimport ... " get the datatable out of this database and put it in my database.
Now, I wonder if it isn't possible to fix this two steps in only one, with other words, is it possible to use the command "DoCmd.transferDatabase acimport ..;" or anotherone to retrieve the datatable directly from the database in the attachment of the email to my database.
As far as I know, there is no possiblity to send a MS Access datatable as attachment of an email, without wrapping it in a MS Acces Database or am i wrong about that?
The content of this database consists of only one datatable. Once the email is sent and received,I know how to retrieve the attachment as a whole from this email and put it in a folder on my harddisk. Therefore I use the command SaveAsFile e.g.
If olAtt.FileName = "Orders.accdb" Then
olAtt.SaveAsFile MyPath & olAtt.Filename
End If ' (olAtt is a attachment-)
After that i can with a "DoCmd.transferDatabase acimport ... " get the datatable out of this database and put it in my database.
Now, I wonder if it isn't possible to fix this two steps in only one, with other words, is it possible to use the command "DoCmd.transferDatabase acimport ..;" or anotherone to retrieve the datatable directly from the database in the attachment of the email to my database.
As far as I know, there is no possiblity to send a MS Access datatable as attachment of an email, without wrapping it in a MS Acces Database or am i wrong about that?
