.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Server drafts location not being saved Excel 2007

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :SharePoint
 
Hi, I have problem with "Server drafts location" not being remembered. And my "Server drafts location on this computer" button is not even checked but I still get the message: "The server drafts location you entered for offline editing is not valid or you do not have permission to access that location. Please specify a location on your local computer" Even if I change and choose a place for this it renders this message as soon as I for example "Adjusted List". Every thing I change in "Excel Options" renders the above message. I have full control over the "Application data" folder as well. Please see if you can help out since this is really giving me trouble in my daily work. I have Microsoft Windows XP professional sp 3 and Office 2007 latest sp. Thanks in advance! Mari


View Complete Post


More Related Resource Links

OpenSearch Location Builder Tool for SharePoint Server 2007

  
Download the tool and start using it to create an OpenSearch Description (.osdx) file to connect SharePoint Server 2007 sites to the Windows Client via the OpenSearch protocol.

Interacting with the Excel Web Services API for SharePoint Server 2007

  
Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Publishing Excel 2007 Workbooks to SharePoint Server 2007 (Visual How To)

  
Watch the video and explore code as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Sample: Publishing Excel 2007 Workbooks to SharePoint Server 2007

  
Explore the code in this visual how-to article as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Linked Server to access Excel 2007

  

Hi

I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.

Apparently the query requires the sql account to have SYSADMIN privileges.

Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.

Following is my code.


Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\202.46.215.35\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'
Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULL
go
SELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')
Exec sp_dropserver 'AB2','droplogins'


Now i get the following error

Error.15247-User does not have permission to perform this action

My Excel file, Database and Windows Application run on separate machines.

i have provided the following privileges

GRANT ALTER ANY LOGIN TO sqlaccount
GRANT ALTER ANY LINKED SERVER TO sqlaccount


EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE

The DisAllowAdHocProcess in

Linked Server to access Excel 2007

  
Hi I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0. Apparently the query requires the sql account to have SYSADMIN privileges. Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method. Following is my code. Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\202.46.215.35\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1' Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULL go SELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]') Exec sp_dropserver 'AB2','droplogins' Now i get the following error Error.15247-User does not have permission to perform this action If I execute the query from Query Analyzer it works fine, but fails when I execute it using Windows App and encapsulate code in Stored Proc. My Excel file, Database and Windows Application run on separate machines. i have provided the following privileges GRANT ALTER ANY LOGIN TO sqlaccount GRANT ALTER ANY LINKED SERVER TO sqlaccount EXEC sp_configure 'show advanced options', 1 RECONFIGURE EXEC sp_configure 'ad hoc distributed queries', 1 RECONFIGURE The DisAllowAdHocProcess in Registry has value 0 Please let me know what additional permissions should i set to get it working???

"Document not Saved" in Excel 2007 - using Windows XP Pro and Office 2007 Pro

  
Hello folks,   I am having an issue with all of my Excel documents saving from the network drive.  Whether I open the document then "save as" 97- 2003 or just do a straight "save" it will always come up as "Document not saved".  I open some Word files and get a different error, "There has been a network or file permission error.  The network connection may be lost (the drive contents here)"  Now I am online and can do emails and open other documents from the network so I know my network connection is not lost.  I work right off the LAN and not wireless.   I did take the file in both Excel and Word and copy them to the local drive then try the open / save as and it will work great like that no problem.  Although this is a "work around" is there something I am missing?  Our corporation has many new machines running Windows XP Pro along with Office 2007 Pro and this was the first I had seen this problem with.  This is a laptop, but again others work fine ( that I know of)   Thanks, Mark

Feeding Excel 2007 .XLSX doc to an SQL server

  

I need some way to read in an Excel 2007 file (xlsx or xls) to a SQL database.  What's the best method to do this?  Do I convert to XML first?  Can I read in an XLS file instead?  Or is there a more suitable format to convert to?  The Excel file contains a very large table too large to print (except in large format printing).  All I want is to store this data in a database that, when queried, returns the same data in a table, but in different ways.  And are there some sample C# code that I could use, at least to show how to read the file in and write it to the database?  I can do everything else.  I'm using SQL server 2008 Developer edition.  Thanks.


Hyperlinks embedeed in excel change when checked out in sharepoint 2007 and saved as local copies.

  

I have an excel folder that is used by several people.  Each has the ability to edit and save changes to track training classes they have attended.  Each person's name in column a is a hyperlink to a sharepoint folder to which is only accessible by the individual and their managers.  When a user checks out the document, they are asked if they want to open the file as a local draft.  If they select yes, when the document is saved back to sharepoint the hyperlinks have changed to the local copy of the user's workstation.  This prevents users from accessing their folders.

Can I turn off the ability to save to a local copy?  How can I prevent the hyperlinks from changing?

thanks


How can I download an Excel file saved on the same server as an asp.Net website?

  

Hello,

I able to successfully see all the Excel files in the given folder using the datagrid and code below. Now I would like to be able to click the link to the file, or add a button, to get a download file dialog box. Can someone please help me.

Thanks!


MarkUp:


<asp:datagrid id="FileGrid" runat="server" 
    AutoGenerateColumns="False" AllowSorting="True">
    <Columns>
        <asp:TemplateColumn HeaderText="File" >
            <ItemTemplate>
                <asp:HyperLink id="systemLink" runat="server" 
                NavigateUrl='<%# DataBinder.Eval(Container, "DataItem") %>'
                Text='<%# DataBinder.Eval(Container, "DataItem") %>' />
            </ItemTemplate>
        </asp:TemplateColumn>
        <asp:BoundColumn DataField="Length" HeaderText="File Size" />
        <asp:BoundColumn DataField="LastWriteTime" HeaderText="Last Modified" />
    </Columns>
</asp:datagrid> 



CodeBehind:


Imports System.IO

Partial Class pageclass

Excel 2007 Spreadsheet - need to import it to SQL Server 2005

  

Trying to import spreadsheet from Excel 2007 to a table in SQL Server 2005, when I follow the steps for a linked server ,, I am able to create a linked server but because the instructions I am following are calling for a Microsoft 4.0 Jet something or another as "Provider" and I do not have that I am getting an error.. I have the a list of providers but the 4.0 Jet is not one of them...

 

Any help is greatly appreciated


Export to Excel 2007 Problem - SQL Server 2008

  

 

Hi! I did a quick test to dump data into an Excel spreadsheet. Everything worked fine, but when I created a job to do this for me and then run it, I get this error:

 

Date  10/8/2008 4:24:25 PM
Log  Job History (ExportClientInfoToSpreadsheet)

Step ID  1
Server  OHI0056
Job Name  ExportClientInfoToSpreadsheet
Step Name  CreateExcelClientExport
Duration  00:00:00
Sql Severity  0
Sql Message ID  0
Operator Emailed  
Operator Net sent  
Operator Paged  
Retries Attempted  0

Message
Executed as user: OHI0056\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Option "12.0;HDR=YES;" is not valid.  The command line parameters are invalid.  The step failed.

 

Here is the script of the job. Any ideas what is going on?

 

Thanks!

 

 

USE [msdb]

GO

/****** Object: Job [ExportClientInfoT

Cannot update Excel 2007 spreadsheet as linked server within SQL 2005 or SQL 2008 via ADO

  
Greetings!

I am having difficulty updating an Excel worksheet via the ACE.OLEDB.12.0
provider.

I have a worksheet defined as a linked server in SQL Server via this
provider, and all attempts to update the lone worksheet in this file as a
linked server results in the following:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel"
returned message "Bookmark is invalid.".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider
"Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel".

The query:
update linked_excel...sheet1$ set error_col='hithere' where
)='G'

However, when I try to perform precisely the same update against the same
source via openrowset, it works, to-wit:

update openrowset('Microsoft.ACE.OLEDB.12.0','Excel
12.0;HDR=yes;Database=f:\path_to_file\filename.xlsx','select * from
[sheet1$]')
set error_col='hithere'
where
='G'

SELECT's performed against either version work properly.

The linked server behavior is consistent across SQL 2005 and 2008
installations.

I am concerned that this problem is an artifact of an OLEDB provider update that purposely disabled update b

While Importing Excel 2007 file to Datatable - headerrow problem

  

Hi there,

 

I am trying to simply extract an excel data from an uploaded file an put it into a datatable. In this case the excel file has 3 rows but when I fill the datatable I only see row count of 2.

I tried changing HDR:NO; to HDR:YES and vice versa, but no luck. 

What am I doing wrong? (Note: the excel file cannot have a  headerrow)

 

string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR:NO;\"";
            OleDbConnection conn = new OleDbConnection(connstr);
            conn.Open();
            DataTable dtTables = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
            string strTablename = dtTables.Rows[0]["TABLE_NAME"].ToString();
            string strSQL = "SELECT * FROM [" + strTablename + "]";

            OleDbCommand cmd = new OleDbCommand(strSQL, conn);

            
            DataTable dt = new DataTable();
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            da.Fill(dt);
            //At this point row count=2 which doesn't make sense


 

 

 


Excel 2007

  

Hi,

 

I want to develop an application which supports Server Side Excel Automation using a template(xltx). I am able to acheive most of the automation except(using excelpackage.dll - OfficeOpenXml), i am stuck up identifying the checkbox controls in my excel work sheet.

Any help on this is really appreciated.

 

My sample code.

 

Thanks,

Ram.


display data in excel 2007

  

 I am using .net  version 1.1  and  excel 2003 to display data.I need to display data in 2007 .Can  anyone suggest the reference to be added ,connection string change and what should be imported.  


Talk Back: Voice Response Workflows with Speech Server 2007

  

Speech Server 2007 lets you create sophisticated voice-response applications with Microsoft .NET Framework and Visual Studio tool integration. Here's how.

Michael Dunn

MSDN Magazine April 2008


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend