Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue updating XLS using ADO
The bug discussed in Q293828 relates to updating Excel using an ADO
recordset. If you are updating a single cell you probably don't need to use a recordset object. Try using an UPDATE SQL statement e.g. UPDATE [Sheet1$] SET Surname='Doh' WHERE RefID=90 Execute the statement using the Connection/Command object's Execute method. You said '"Open' the updated XLS in a new MS-EXCEL session". Does this mean you already have the XLS open in an existing session? If so you should also be aware of the memory leak bug, article Q319998). I've certainly had problems with Excel crashing due to the target workbook being open. "RAV" wrote in message ... Hi, I need to update a single cell in an XLS file from an ASP page. The requirement is to have this happen on the Web Server without having to install MSOffice (or MSExcel) on the server. Upon browsing MSDN documentation I came across the ability of updating XLS (MS-EXCEL) files from ASP using ADO's OLEDB Jet driver. When I try this it works (PSS ID number in MSDN for the article is Q278973) but the issue is that once the XLS is updated and ASP script finish's execution, trying to open the updated XLS file, either thru ASP or from the MS-Excel app., results in a crash. MSDN article with PSS ID number Q293828 talks about a bug when the above approach is used but the resolution suggested in MSDN (which is to "Open" the updated XLS in a new MS-EXCEL session and saving it again) doesnt work as MS-Excel crashes whenever I try to open the updated XLS file. Can someone please tell me if this approach of updating XLS file from an ASP page is a reliable one, if yes are there any service packs (MDAC etc) that should be applied to resolve the problem described above. Any help on this will be much appreciated as I am badly in need of a quick solution to this problem. Thanks in advance, Regards Rajesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with the Camera Button for creating dynamically updating pic | Excel Discussion (Misc queries) | |||
Speed Issue after updating cells | Excel Discussion (Misc queries) | |||
Updating | Excel Discussion (Misc queries) | |||
DDE and updating | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |