Databases :: Mysql Database And Find Return Resul In Excel File This Give Me A Chart And Other Sheet?
Dec 20, 2010
I have a problem that currently we are use a sybase database and we want to create application that give me a output in excel report that's mean my data stored at sybase or mysql and we access it from this after it generate my report in excel form and give this output on excel format?
I have the following code i found online and it works fine as long as the sheet names are simple names it seems..
If i have a excel file with a sheet name of (sheet1) the code works.. but if i have a file with a sheet name like (FileName2011_03_03_15_01_43) it fails and causes the rest of my code not work..
I'm looking for a way to parse excel into Asp.Net, the problem I'm experiencing same as in[ URL]
I've searched all web, but no1 seems to have an answer
here's the error
The Microsoft Jet database engine could not find the object 'Cities'. Make sure the object exists and that you spell its name and the path name correctly.
I want to fetch data from a excel sheet. Can anyone tell me how we can acheive this I also want to edit that data and then again place it on excel sheet.
i want to find data from excel sheet using c# my excel sheet like this
Sr. No. Store Code Store Name City State 1 3062 C.G.Road. Ahmedabad Gujarat 2 3103 Iscon Mega Mall 2 Rajkot Gujarat 3 3113 New Gandhi Nagar Ghaziabad Delhi 4........................
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM." below I paste some code snippest.
i got the different datatable value using different query.Now i want to export to excel at the single sheet like datatable1 to sheet1 and datatable2 to sheet2 .
i have made a connection and retrieve the data from the excel sheet. however when i run a query to update or insert some data into excel sheet it will generate an error "Cannot expand named range"
there is broblum for uploading excel sheet when my application runing on local host but there is no problum on vs enviroment . i am using the following connection string code
In Visual Web Developer 2008, creating new sqldatasource connection, I not find ".NET Framework Data Provider for MySQL". I have already installed MySQL Connector/Net 6.2. I could add a reference to MySql.Data. Why!
I am working on a function that when i click a button, the chart control can be exported to an excel file. I have tried searching googles, but no post related can be found.
I am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.