best way to get an updatable SQL Server 2000 recordset into Excel?
 

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

best way to get an updatable SQL Server 2000 recordset intoExcel?
 

Did I post to the wrong group?

best way to get an updatable SQL Server 2000 recordset into Excel?
 

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