This topic is locked

Deleting data in a linked table is not supported b

7/22/2004 11:38:25 AM
ASPRunnerPro General questions
swat author

hi admin-
I'm getting the following error:
Error number: -2147467259
Description: [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM.
SQL query: delete from [Sheet1$] where Issuer='BAC'
I am using ASPrunner3.0 and excel file as DB

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=731&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />

Sergey Kornilov admin 8/4/2004

Swat,
I'm not sure what exactly is happens here. Probably you have a reference to another Excel worksheet that cannot be deleted.
Anyway I won't recommend to use Excel as a database backend for ASP application.