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ää: 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

Tietoa työnantajasta:
( 91 arvostelua ) Cairo, Egypt

Projektin tunnus: #1727231

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

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

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

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

Understood. Please che my private message. BR

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

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

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

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

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

i have skills to do this project with high standard.

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

please check private message

$30 USD 3 päivässä
(0 arvostelua)

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)

i can do it for you!

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

I can develop this project using Excel and Sqlserver 2008

$80 USD 7 päivässä
(0 arvostelua)

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)