Some time back i posted for help in uploading CSV file to DB. With the assistance of other members, i was able to set that up on a test page and got the functionality working.. Now project is coming to the end and need to take that code / logic and incorporate with our application.
On certain forms, we need to allow the user to export / import via a CSV file.. So this question is muti part for each function.
#1 Export = Since each form is unique, how can i setup the page to export that forms data that is currently in the DB? (I've used this control before http://exporttoexcel.codeplex.com/ and worked great) for excel. This may work fine for exporting the data out of the db for the user.
#2 Import, if the above is used or some other solution to export the specific table data, is there anyway to validate that the csv file that is being uploaded contains all the columns and is in the correct order? I mean if they were to export the data, but come back few days later to import it, and didnt realize that they selected a csv for another page or maybe they picked the right file, but while editing it they removed a comma or entered some data that would throw the format out of wack.. just looking for a way to read the selected file to import and compare to the table it is suppose to go into and make
View Complete Post