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

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
 
J

J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trasfer data to SQL Server 5
Excel 2007 to SQL Server??? 1
Excel as front end and SQL Server as back end 0
Excel crash closing ADO connection object 4
ado connection to access vs. sql server? 7
Best way to call a SQL Server Stored Procedure from within Excel 2
Help - Update a SQL table from a specific range in Excel 2
Autonumbers in SQL Server Recordsets 2

Top