View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Bragas[_2_] Eric Bragas[_2_] is offline
external usenet poster
 
Posts: 9
Default 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