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.
View Complete Post
I'm using the following code to upload images, pdf files, word files and excel to a sql table as binary data. However, I can only figure out how to display the images but am clueless about the other type of files. What adjustments do I need to make so that with a button click I can access the other files? 't By the way, I'm using an image control to display the binary data and I'm aware that that will only work to display images, I just don't how to access all the other types of files once uploaded. Thanks
Partial Class Uploads_UReceipts
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Request.QueryString("ImageID") IsNot Nothing Then
Dim strQuery As String = "select Name, ContentType, Data from tblFiles where id=@id"
Dim cmd As SqlCommand = New SqlCommand(strQuery)
I have 3 excel files having uniqe column Name JobNo. i want to develop a web page containing serach option based on Jobno.
User just type the jobno and press on search button corresponding record should be display on grid view.record may present any of the excel sheet.how can i acheive this.please provide me the code.
I have an excel file (xlsx) containing a table :
Once I launched my ssis task (successfully) to insert data in it, it is actually append after the table :
So I am looking for a way to insert into the table and expand it with the data. I hope someone could help me.
Thank you !
Environment: Win server 2003 , Office2007, SQL Server2003, PowerPivot for Excel
All the user do have access to connect the cube. am the admin user and i get the same error message.
"Initialization of the data source failed. Check the database or contact your database administrator. Make sure the external database is avaliable, and then try to operation again.
I have tried deleteing the data source and creating a new one.
Can any one help with this there are other fourms on this but i can't see a answer for it.
First off, I am not running on a 64 bit machine.
I keep getting the following error when I try to run a task that has an ODBC connection to an xlsx file on a SQL Server 2005 server using SQL Server Agent.
Executed as user: ACCT02\ssc_emr_ra. ... 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:29:39 AM Error: 2010-10-28 07:29:42.63 Code: 0xC0202009
Source: RFC_Data_Load Connection manager "Excel ODBC Connection" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft
OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2010-10-28 07:29:42.63 Code: 0xC020801C Source: Data Flow Task OLE DB Source 
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel ODBC Connection" failed with error code 0xC0202009. There may be error messages posted before this
with more information on why the AcquireConnection method c
Recent install of add in Excel data mining on excel 2007 when I press the classification matrix button for example it gives me the error : A connection to analysis service is required to perform the classification matrix task. Click the no connection
button on the data mining tool bar to create a new connection.
I click new connection then new,, I type in my name , and then test connection then another error Test connection Failed Aconnection cannot be made ensure that the server is running : No such host is known.
Can someone please help me with this so i may use the data mining feature on my spread sheets thanks in advance :]
My problem sounds like that:
I have some cube created with SSAS 2008 and I'm using Excel 2007 as browser to view cube data.
I made pivot table with nessesary data, everything works fine till I save excel file and sent it to my client.
When client uses some filter, some row measures disapear. Dimension data are shown, measures are blank cells, but calculations from those measures is filled.
e.g. I see difference of sales between years in percent, but I can't see measures, which were used to count that difference, because in excel I see blank cells.
Does any one knows where can i get Data Mining add in for Excel 2007 video tutorials? (Classify, Estimate,Cluster, Associate, Etc.)
All i can find are videos tutorials for Data Mining table analysis tool.
I install add-in and run fine for a while, then all of sudden I could not see Table Analyze tool and data mining tab at my ribbon. I re-run server configuration and re-connect to DMAddinDB (remote server, but I am the administrator), but data mining add-in and table analyzer still not showing at my ribbon.
Then I uninstall DMAddin, re-install it, go through configuration again, but still the tabs are not showing up.
Any idea you can help me get my add in back?