Import 4-5 CSV Files into a SQL Table - Daily - Send report by email

This project was successfully completed by marasinghe82 for $111 USD in 3 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
Project Description




1. Import all 4-5 CSV Files into 4-5 tables

Import will do the following:

a. import new records

b. update existing record if change is found

c. update record with "not available" if record not found

d. datestamp any records that require update, new, any type of change

You will then generate a report with the following:

• Records # added,

• # deleted,

• # updated,

• what csv file (single family, condo, rental, highrise, midrise, multi-family)

• update that information into a table called “ImportReport”

• create a email using db agent and send out that information on every import

Report will:

* we will run this import every hour

• we will run this import on an increment csvfile that is generated using our secondary software. I will show you how this system works to generate the csv file and increment file.

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online