Peruttu

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.

Taidot: .NET, SQL, Visual Basic

Näytä lisää: dynamically read database, sql server web, loop net, copy write name, best excel spreadsheets, ask excel, sql server programmer, vb excel, read, excel formulas, excel database visual basic, sql server 2008 access, excel contains, programmatically, multiple excel, excel access table, excel net read write, read write server using, excel row column, sql server access excel, excel read cell value, sql view table, visual read files, excel sql create, please read word

About the Employer:
( 91 reviews ) Cairo, Egypt

Projektin tunnus: #1727231

11 freelanceria on tarjonnut keskimäärin 145 $ tähän työhön

MMaghawry

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

300 $ USD 7 päivässä
(52 arvostelua)
5.7
marasinghe82

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

100 $ USD 1 päivässä
(27 arvostelua)
4.6
lorjnr

Understood. Please che my private message. BR

295 $ USD 7 päivässä
(5 arvostelua)
3.6
GlobalProduct

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

150 $ USD 14 päivässä
(1 arvostelu)
0.0
NembooliSoft

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

60 $ USD 6 päivässä
(0 arvostelua)
0.0
mrchamila

i have skills to do this project with high standard.

100 $ USD 10 päivässä
(0 arvostelua)
0.0
srisskto

please check private message

30 $ USD 3 päivässä
(0 arvostelua)
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 Lisää

250 $ USD 7 päivässä
(0 arvostelua)
0.0
freebid

i can do it for you!

31 $ USD 8 päivässä
(0 arvostelua)
0.0
ashanker

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

80 $ USD 7 päivässä
(0 arvostelua)
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 Lisää

200 $ USD 7 päivässä
(0 arvostelua)
0.0