how to make Excel linked to SQL Server 2005 worksheet editable?

P

Permood

I have Excel 2007 workbook which is linked to SQL Server 2005 using sql
server connection (odc) file. but i can't update the records in excel file. I
would like to update records or delete them

is it possible to make it editable?
if yes, how to do that?

Thanks for help
 

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

Embedded Excel into Word with Tables 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Adding data to MS Access from csv file 0
ODC properties: OLAP Server Formatting 0
Embed the same Excel multiple times 0
Visio to Excel 0
Editing sql server data in Excel 2007 0

Top