I want to give users the ability to upload database on CF pages. A table in SQL Server is already defined, and what they need to do is just uploading the data from an Excel file into the existing table by clicking on 'Submit/Upload button'. The Excel file has the same columns as the table in SQL Server has. They can either append or delete the existing data and insert the new data when uploading the data. This is something like Data Transformation Services (DTS). Please let me know how to approach.
tia ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54