Cancelled

Dynamically programmatically read Excel Access to Create SQL Server Database aspx 2

1. Present user with basic interface to select files on local machine. then Read multiple spreadsheets or files as well as Access db and create sql server database using the data.

2. Present to user data preview and predetermine best format of column (datatype: eg date, string), allowing to choose format of each column, and let user know which row and cell value that would result in inconsistency or loss of data for selected format. Do not copy formulas, just values.

3. Asks user to confirm/provide table name.

4. Ask user if first row contains column headings and allowing user to view, confirm each new column name. Column name has few limitations would be provided to programmer..

5. After importing tables, loop through tables asking user if each table relates to others and using which column and if child parent or many-many. When it does, create a PK/FK relation or cross referencing/linking table.

VB. net 2008 - Web interface. SQL Server 2008

Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.

Skills: .NET, SQL, Visual Basic

See more: programmatically excel read sql server 2008, dynamically read database, dynamically read excel create table sql server, sql server web, loop net, copy write your name, best excel spreadsheets, ask excel, create access database net 2008 programmatically, vb in excel, sql server programmer, vb excel, sql server c# 2008, read, net sql server, net c# sql server, excel with sql server, excel to sql, Excel Formulas, excel $2-30, access to sql, excel database visual basic, sql server 2008 access, excel contains, programmatically

About the Employer:
( 91 reviews ) Cairo, Egypt

Project ID: #1727231

11 freelancers are bidding on average $145 for this job

MMaghawry

Understood , But regarding the steps lets me do it after accepting me as your provider.

$300 USD in 7 days
(52 Reviews)
5.7
marasinghe82

Dear Sir, Please assign this task for me I can assure 100% completion. Best Regards, Jinesh

$100 USD in 1 day
(27 Reviews)
4.6
lorjnr

Understood. Please che my private message. BR

$295 USD in 7 days
(5 Reviews)
3.6
GlobalProduct

We are a group of software developers believe in providing high quality software in promised deadlines

$150 USD in 14 days
(1 Review)
0.0
NembooliSoft

I am expert in various kinds of databases I an good programer...

$60 USD in 6 days
(0 Reviews)
0.0
mrchamila

i have skills to do this project with high standard.

$100 USD in 10 days
(0 Reviews)
0.0
srisskto

please check private message

$30 USD in 3 days
(0 Reviews)
0.0
ManojPriyanka

Understood...Please see private message for steps. I am microsoft certified technical specialist. I have worked on such project previously i.e. read data from excel and create different report in excel/powerpoint and More

$250 USD in 7 days
(0 Reviews)
0.0
freebid

i can do it for you!

$31 USD in 8 days
(0 Reviews)
0.0
ashanker

I can develop this project using C#.net Excel and Sqlserver 2008

$80 USD in 7 days
(0 Reviews)
0.0
xizhezhang

Understood. A. confirm 1. excel/acces formats 2003,2007 or 2010. 2. multiple users or sigle user to upload the files B. steps 1. database design 2. 5 web pages: upload, preview, assign, confirm, final 3. server More

$200 USD in 7 days
(0 Reviews)
0.0