Hello,

What is the best way to get an updatable recordset into Excel 2007?
I've the built-in functions but the recordset is not updatable. I
know this because I can right-click on my dataset and choose
"refresh," and my corrections disappear, being replaced by the
original data in the SQL Server 2000 table.

Any suggestions? I'm not such a great user, but I would prefer not to
have to develop an entire solution for this. There's got to be a
built-in method somewhere.

Thanks,
Eric

Did I post to the wrong group?

Check your permissions in SQL most likley you have no datawrite permissions -
really should be posted onto an SQL newsgroup btw.

"Eric Bragas" wrote:

> Hello,
>
> What is the best way to get an updatable recordset into Excel 2007?
> I've the built-in functions but the recordset is not updatable. I
> know this because I can right-click on my dataset and choose
> "refresh," and my corrections disappear, being replaced by the
> original data in the SQL Server 2000 table.
>
> Any suggestions? I'm not such a great user, but I would prefer not to
> have to develop an entire solution for this. There's got to be a
> built-in method somewhere.
>
> Thanks,
> Eric
>