Terminé

Drag and drop Excel file on web site loads to Access database(repost)

Summary:

* I want a simple 1 page website (no graphic design necessary) where I could drag and drop an Excel file onto the webpage, and the site would load the Excel file into an Access Database table (same # of columns and column names).?

* I will be loading files daily, so after the first file, the site? would append the new data to the table each time.?

* After the file has completed loading, a dialog box would indicate that it has successfully been loaded.? I should be able to click OK to close the dialog box, and the site should be ready to allow another drag and drop load (the data would append to the same table).

* Duplicate records should be skipped (based on primary key), but a file containing duplicates should load all non duplicate rows? and show "success" on the resulting dialog box with the number of rows skipped.

* If the file does not match the # of columns or has some other issue, the web page should provide a popup indicating that the file could not be loaded and why.

* Optional: a progress bar showing the percentage complete as the file is loading into access

Requirements:

* coded in VB.NET

* Access 2003 compliant

* all source code must be provided

Excel File Details:

* The files will contain ~1000 records, so I would need to know if there are any size limitations in Access.?

* The excel file contains 53 columns.? ?

Deliverables:

* 1 aspx file with source code

* 1 mdb file with 1 table, and sample data loaded (from file I will provide)

I will provide you with the first file for testing.

Compétences : ASP, PHP

en voir plus : web design drag and drop, summary web design, summary on graphic design, mdb files, i need an access database, graphic design database, drag and website design, drag and drop web design, drag and drop design website, design on web, design access database, daily access, 3 column web design, vb in excel, webpage or web page, vb excel, loads, Excel to Access, Excel file, excel duplicate

Concernant l'employeur :
( 1 commentaire ) United States

Nº du projet : #3362710

Décerné à:

petipogled

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(18 Commentaires)
3.7

4 freelance font une offre moyenne de $155 pour ce travail

shawnburt

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(122 Commentaires)
6.5
vw1684705vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.0
arkotechlx

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0