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

  • Thread starter Thread starter Eric Bragas
  • Start date Start date
E

Eric Bragas

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
 
Check your permissions in SQL most likley you have no datawrite permissions -
really should be posted onto an SQL newsgroup btw.
 
Back
Top