It is possible to import or export data to Excel using OpenRowset. I
want to delete Excel data before inserting data to it using OpenRowSet,
I get this error

Server: Msg 7345, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' could not delete from table
'SELECT * FROM [t$]'. There was a recoverable, provider-specific error,
such as an RPC failure.
[OLE/DB provider returned message: Deleting data in a linked table is
not supported by this ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IRowsetChange::DeleteRows returned 0x80040e21:  DBROWSTATUS_E_FAIL].

Is it possible to delete Excel data using OpenRowSet?

Madhivanan

Isnt it possible?

Madhivanan

Dynamic WHERE & Dates
with(updlock) - How many times on same table in single update?
Composing a date from date parts
Delete Query ?
DateName always return DatePart!