Đã Hủy

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.

Kỹ năng: .NET, SQL, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 91 nhận xét ) Cairo, Egypt

Mã Dự Án: #1727231

11 freelancer đang chào giá trung bình $145 cho công việc này

MMaghawry

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

$300 USD trong 7 ngày
(52 Đánh Giá)
5.7
marasinghe82

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

$100 USD trong 1 ngày
(27 Đánh Giá)
4.6
lorjnr

Understood. Please che my private message. BR

$295 USD trong 7 ngày
(5 Đánh Giá)
3.6
GlobalProduct

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

$150 USD trong 14 ngày
(1 Đánh Giá)
0.0
NembooliSoft

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

$60 USD trong 6 ngày
(0 Đánh Giá)
0.0
mrchamila

i have skills to do this project with high standard.

$100 USD trong 10 ngày
(0 Đánh Giá)
0.0
srisskto

please check private message

$30 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$250 USD trong 7 ngày
(0 Đánh Giá)
0.0
freebid

i can do it for you!

$31 USD trong 8 ngày
(0 Đánh Giá)
0.0
ashanker

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

$80 USD trong 7 ngày
(0 Đánh Giá)
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 Thêm

$200 USD trong 7 ngày
(0 Đánh Giá)
0.0