View Complete Post
One of the coolest new parts of Office 2003 is a programmability feature called Smart Documents, which allows developers to augment Word and Excel documents with programmable content and behavior. Typically, examples illustrating Office programmability use Visual Basic or Visual Basic .NET. In this article, the author develops a Smart Document for Excel using C++. He describes the new ISmartDocument interface and shows how to use it to manage a simple task list such as an Excel spreadsheet.
MSDN Magazine December 2003
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','\\126.96.36.199\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * 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 sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in
Hello Sharepoint experts:
I'm testing our recently set up Kerberos with Sharepoint, Excel Services, and some SSAS Cubes.
I create an Excel Pivot table using a Trusted Connection to a cube, the "Refresh Data when opening file" is checked. The file is published to a Trusted Excel Services location in Sharepoint. I then create a Dashboard and add an Excel Web Part to display
that pivot table. All works fine on my machine. When I get another user (one who does NOT have access to this cube) to go to the Dashboard page, that user can see all the data in the Pivot table.
If I then DELETE the cube that the Pivot table is based on, when the user (who never had access to it in the first place) goes to the Dashboard page, they get an error stating that the source may be unreachable or that access may be denied. This error is
expected. But what I DON'T expect is to NOT receive an error the first time
Seems that even if the user does NOT have access to the cube, Excel Services still lets them see the 'last saved version of the file' even though it is supposed to query the database for new results every time.
AND when I restore the cube WITH CHANGES, that user can then not only see the pivot table again, they can see the recent changes, even though the original file in Trusted Excel Services Locations was never updated.
Is it possi
I am trying to import from an Excel spreadsheet or an Access database into an Oracle table. I used the SSIS Import and Export wizard to create the SSIS packages, but everytime that I attempt to run the package, SSIS stops once it gets to the Pre-Execute
phase. There are never any errors. Am I doing something that cannot be done?
I'm using the following: SSIS 2005, Microsoft Oracle OLEDB provider (MSDAORA.1), Excel and Access 2003
By the way, I am able to successfully export from the Oracle database to either Excel or Access using SSIS.
I am trying to import an excel content to a SharePoint list. When I choose an excel file and import I am saving the file Using "Microsoft.Office.Interop.Excel" object to the temporary folder location and reading it from there. When I try opening a file
using "Microsoft.Office.Interop.Excel.Application.Workbooks.Open" I am getting the following error.
Microsoft Excel cannot access the file "TEMP" folder. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
I have tried impersonating the INTERACTIVE USER account. But this looks like the excel object doesn't have permission. Please share your inputs on this issue.
I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error :
Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'. There are several possible reasons:
. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.
At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website?
In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required.
Please help. I am in great trouble. Thanks in advance.
Is it possible to access data from an Excel SpreadSheet hosted on SharePoint (2007 MOSS 64 bit) via SQL Server? We have a requirement to calculate metrics where part of the data is in SP Lists, and part of the data is in Excel spreadsheets in
Any feedback is greatly appreciated!
As far as i know, excel services require enterprise licensing. Anyway, now in office 2010 - the office web apps (which include excel in web) are included also in the standard edition.
So - in case i want to publish excel in SharePoint - are both editions may work? which functionality do we miss when having just the standard edition? (interactivity? use parameters?...)