<div>
I will give that a try, thanks!
</div>


<div>
Another alternative once the excel file is uploaded to the server, is to open up a database connection against the excel file and get the data in the ASP code. There you can do what you want to it, and compare it to the data in the SQL Server database to decide what to update.
</div>


Another alternative once the excel file is uploaded to the server, is to open up a database connection against the excel file and get the data in the ASP code. There you can do what you want to it, and compare it to the data in the SQL Server database to decide what to update.

<div>
I want to thank you for your help! It did the trick after some work.
</div>


I want to thank you for your help! It did the trick after some work.

<div>
<div class="content wysiwyg-content">
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 &nbsp;importing it to the database.<br />
<br />
Thanks in advance for your help.
</div>
</div>


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.

Thanks in advance for your help.

Import Database Script using ASP (ability to upload excel data to SQL 2005)

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.