Excel File

edward_m · Post by **edward_m** » Tue Apr 29, 2008 1:05 pm

ArndW wrote:Does "UPDATE" work? ...

No..I have tried only update action as exixtsing rows and it gave me the same error.

Thanks

edward_m · Post by **edward_m** » Tue Apr 29, 2008 1:49 pm

ds_developer wrote:You might want to look into the following article at Microsoft:

http://support.microsoft.com/kb/175168

John

Thank you so much ds_developer..
Now i am able to write data into excel file.
Solution..I have reconfigured DSN to uncheck driver Read only option..By default System DSN driver read only option enabled.

Using the above change i am able to insert and update the data on excel file.

When i try to delete data from excel file i am getting the following error..
xlstest..Transformer_4: |xlstest..ODBC_0.DSLink5: DSD.BCIOpenW call to SQLExecDirect failed.
DELETE FROM `Sheet1$`
SQLSTATE=S1000, DBMS.CODE=-5410
[DataStage][SQL Client][ODBC][Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM.|