Upload Excel and store in SQL Server

[cfsponge]

Does anyone know of a sound technique or tutorial for A) uploading Excel sheet via HTTP, and B) parsing Excel fields for SQL Server storage?

 

[Sheco]

Do a google search for "pure asp upload" and that should get you started with uploading a file.

Then, once you get the file up... I'd look into connecting to it via ADO using an ODBC driver for Excel. If at all possible I would avoid actually creating any instances of the Excel application on the web server.

 

[cfsponge]

The site connection is OLEDB. Does this affect not having to create an Excel app instance.

 

[Sheco]

OLEDB is fine it also works with ADO... these drivers should be able to parse the XLS file without actually starting an instance of Excel which is something you definately want to avoid on the web server.

 

[cfsponge]

Thanks for the information.