Auto upload the attachments through VB

[high100]

Hi Experts,

I receive Access attachments to my mailbox then I download them to one local folder & this data is uploaded to SQL Server 2k using VB6 form.

Is it possible to upload access database attachments directly to SQL Server without downloading them to Local folder/drive.

Thanks in advance.

 

[HiTechCoach]

Probably based on the way attachments as encodes, they will need to be extracted to the hard drive first.

If you are using Outlook, you can use VBA within Outlook to automatically save the attachment and call the VB app.