Sql Steptype write to Excel

[j_dodek]

Hi

Since a long time i am using Sql Step type for reading excel spreadsheets.

Now i like to do this the opposite way. - just writing to excel.

Set and Put new Record is getting an Error:

ADODB.Recordset (0x800A0CB3)
 Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

Has anyone eperience with that. or will that not work with TS here?

Regards

Juergen

[j_dodek · Accepted solution]

Hi,

I have solved it by getting rid of "IMEX=1" in the connection string.

Now it looks like that:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test.xls;Mode=ReadWrite;Extended Properties="Excel 12.0;HDR=YES";Persist Security Info=False

Regards

Juergen