ASP code for Closing Processes?

is there such a beast

[txbakers]

I'm running a routine that reads through an excel file and populates a database.

If there is an error in the excel file (too many chars, etc.) the routine crashes, and the system process stays open. I have go into the task manager and manually kill the process to end it, so the user can try again.

I need to know how to trap the errors using javascript and the following code:

CMD.ActiveConnection = SQLCONN;
CMD.CommandText = sqlDET;
CMD.Execute();

Would a try/catch work here? Can someone please post or mail the syntax for me?

Thanks!

[TheNige]

Do you have to explicitly open Excel? Can you use the OLEDB adapters to query the values from the spread sheet?

[txbakers]

I've never tried that one!

Do you have a sample code for that?

[TheNige]

You shold be able to find something on the net by doing a search. But basically you just need to put the path to the Excel file in the connection string. You can use the Jet drivers and then do sql queries on the sheet.

As long as your file is pretty tabular in nature this will work good. If you need to access specific cells then it might be harder.

[txbakers]

Might be able to do ODBC also on it.

I do read by cell, then populate the SQL query.

I'll play.