Import Database Script using ASP (ability to upload excel data to SQL 2005)
I am wondering if it is possible to create an asp script (classic or .NET) that a user can browse their computer for an excel sheet and submit it for upload to a SQL 2005 database. I am needing to provide the ability for someone to upload a spreadsheet to my database to update a record. The spreadsheet will have all the matching columns and it will be identified by a field in the spreadsheet to a field in the database. If this is possible I am also wondering if I could have it strip the first 3 characters of the data in a particular field prior to importing it to the database.