Excel automation

Hi,

I tried to add column headers and delete all rows to excel database
which is a linked server to my sql server db.

I got an error message, "delete data through linked server is not
supported by Isam".

I tried to use FSO to write to the excel file, but seems like FSO
support write to only text file.

the last time I tried to create an excel applicaiton object and temper
with its cell, I hang my Excel application and had to reinstall it.

Have any ideas,

Thank you very much"dlakme" <dthuyuyen@.yahoo.com> wrote in message
news:7bdc161c.0408030437.3ce04385@.posting.google.c om...
> Hi,
> I tried to add column headers and delete all rows to excel database
> which is a linked server to my sql server db.
> I got an error message, "delete data through linked server is not
> supported by Isam".
> I tried to use FSO to write to the excel file, but seems like FSO
> support write to only text file.
> the last time I tried to create an excel applicaiton object and temper
> with its cell, I hang my Excel application and had to reinstall it.
> Have any ideas,
> Thank you very much

I have no idea about your specific error, but it may be easier to use a
client-side tool to pull the data from MSSQL, then use the Excel COM
interface to put that into Excel as you want.

Simonsql