Delphi : Insert Spreadsheet to Table

In Progress Posted Jan 18, 2015 Paid on delivery
In Progress

Need form to insert spreadsheet into SQL table using DevExpress Spreadsheet Control.

Form Requirements:

TeamViewer or Logmein

I will build nice UI for you. You only need be concerned with code and function.

Map Columns

1) Map Table Columns to Spreadsheet Columns using Combo

Check and Highlight

2) Create Functions to verify data in Spreadsheet matches datatype of Table Column and highlight exceptions on spreadsheet (per column only to be easier)

Error Handling

3) Cancel or uncommitt insert (save) on error.

User Rollback

4) Create function to delete last import (save)

Identification

Additional fields will be added to the insert/save to identify and link list

to available queries

DateImported : date saved

ImportedBy : shows who list imported by (available from mainform query (ill show how)

CompanyNo : Links list to a company in a different table

Company : Name of the company (same query)

Contact : I think you should be understanding by now :)

In summary we are saving a sheet to a table with a few extra fields from query

Continued work on features and bug fixes on a continued basis if i like your work

Be skilled master with

Delphi XE

Devexpress Spreadsheet Control

ADO Components

MemData

MSSQL

Delphi Software Architecture SQL

Project ID: #6992043

About the project

3 proposals Remote project Active Jan 21, 2015

Awarded to:

tekwiz2

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$12 USD / hour
(1 Review)
0.0

3 freelancers are bidding on average $18/hour for this job

ENRICOJ

I AM A DATABASE DEVELOPER AND CAN DO THE JOB IN 24 HOURS. I AM GOING TO CHURCH NOW ,BUT AS SOON AS I AM BACK I WILL BE ABLE TO START REGARDS ENRICO

$16 USD / hour
(0 Reviews)
0.0