Excel automation

[dlakme]

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

[Simon Hayes]

"dlakme" <dt*******@yahoo.com> wrote in message
news:7b**************************@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.

Simon