jerrym
Posts: 52
|
| Posted: 11/30/2006, 4:59 PM |
|
Hi
wondering if anyone has previously imported excel data into a datagrid and then Appended this data to a Table in sql server?
this procedure will probably NOT be a once off occurence. so, i think an upload file option, button to read the excel file then load it into the grid, another button to then append the data to the database.
if anyone has done this before would appreciate some guidance. many thanks.
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/30/2006, 11:24 PM |
|
See
http://forums.codecharge.com/posts.php?post_id=64435
OR if you don't mind spending $48 to $190 USD.
http://www.findy.com/doc_xlintro.asp
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
jerrym
Posts: 52
|
| Posted: 12/01/2006, 1:35 PM |
|
hi edd
i read this posted by you sometime ago, it has a reference to spreadsheet converter whats your opinion between this and findys prodt?
http://forums.codecharge.com/posts.php?post_id=66572&s_...port+from+excel
|
|
|
|
Edd
Posts: 547
|
| Posted: 12/01/2006, 6:54 PM |
|
Jerry,
It depends on your needs:
The findy should be product is where your accounts department send out a speadsheet for expenses and their is an infinite number of rows. And you tell people to cut and paste the rows back into the web page. It is very flexible in that sense.
The spreadsheet converter is where you want to put up a "fixed" spreadsheet and return a single value (or you and filter through the data and pick the values). I have used the spreadsheet converter in 2 ways:
1st Application
As part of an Occupational Hea;th and Saftety intranet site I needed to replace an Excel Swimming Pool Water Testing Log - I didn't need to analyse the data I just needed the data to be recorded and be able to be seen and printed by other people. In this case I store the entire spreasheet and have it locked away until a statutory body wanted to see it.
2nd Application
In one of my client's site they wanted an Insurance calculator where they had an existing speadsheet for clients and they wanted to publish this to the web. I could have coded the whole thing in Javascript and ASP and HTML but this saved me 4 to 5 hours. See
http://www.whitbread.com.au/Form_HomeInsurance.asp - go down half way and click on the calculation button.
You may be able to get away with uploading and processing spreadsheets or use one of the new Ajax spreadsheet controlls. I personally do not like anything that cannot be validated in front of the users, I have found that when it comes to data there is a tendancy for people to "dump and run" so validation in thier faces is very important.
The problem with Excel is that every situation is different, I personally could use both of the products.
I think both offer trials - so give them both a go.
Regards
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
jerrym
Posts: 52
|
| Posted: 12/01/2006, 9:30 PM |
|
hi edd
if a had a user who wanted to add infinite number of rows to a table called Equipment for them to do it manually is quite tedious. hence the spreadsheet upload procedure. sounds like the findy product is more suited for me. trouble is this equipment table is also very important. any mistakes will break the system. what do you think?
|
|
|
|
Edd
Posts: 547
|
| Posted: 12/02/2006, 12:40 AM |
|
You would need to put a lot of validation after the load, checkig for duplcates, etc. I would suggest to go to a work table first, then validate, then post.
I think the findy product sounds like your best option.
Good luck - soundls like you have a bit of work in front of you.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
