Receiving email through SQL server

I am receiving a email every day from my vendor with CSV file attachment.
The CSV file has a vendor products list. Every day I import the CSV file in to the SQL sever table (vendor_Products) manually.

Is it possible to automate the process using SQL job ?

Microsoft SQL Server 2008Microsoft SQL Server

Last Comment

Jesus Rodriguez

8/22/2022 - Mon

Jesus Rodriguez

12/23/2013

You can create an Outlook AddIn that when you receive an email from the vendor then check if the email has an attachment. If the attachment is a list then run the store procedure on the sql that import this into the list or import the list directly from the email attachment.

I Will send you the example to you in a second

SOLUTION

Kevin Cross

12/23/2013

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION