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]

Re: Excel automation


"dlakme" <dthuyuyen@yaho o.com> wrote in message
news:7bdc161c.0 408030437.3ce04 385@posting.goo gle.com...[color=blue]
> 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[/color]

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