Browse by Tags

Home ›

All Tags » excel » database (RSS)

Upload excel data

I need to upload excel file into sql server database. I need to store the specific column from excel file.How to retrive the specific column from excel file.I already uploaded the entire excel file into sql server database.the coding is try { // Connection String to Excel Workbook string excelConnectionString...

Posted to Other Databases (Forum) by kssaranmca2006 on 01-05-2009, 12:00 AM
Filed under: ASP 2.0, database, databases, Dataset to Excel, database connection, database options, asp .net2.0, Excel, excel C#, Excel C# Import Convert VSTO SpreadSheetGear Aspose CSV OLE-DB ASP.NET 3rd-Party, Excel Export
Import 1 column from a excel file to an Database

Hi, Im making an newsletter system in ASP.NET c#. I wil make an option to import an excel file with emailadresses. Its 1 simple column with some emailadresses. When I import it, it must send to an table in my database. I have found some code like this: public DataSet Read(string path, string sheetName...

Posted to Other Databases (Forum) by khalidelmeknesi on 12-18-2007, 12:00 AM
Filed under: database, excel
How to copy data from one excel file to other excel file

Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...

Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control
How can I export Excel data into SQLdatabase table....

Hi,. my company wants their Excel data to be stored in sqldatabase automatically....and if the want any data from sql datbase it should be converted to Excel format..... and i am new to .net... plz help me by gvng ful details...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Rangapure.S.Swapnil on 04-13-2009, 12:00 AM
Filed under: 2005, asp .NET 2.0 SQL login, asp .net sql 2005 express standard, asp.net 2.0, backup database, conversion, Conversion to SQL, conversionsion, convert, Database, excel to sql, export, Export Import, Excel, Excel Data copying
Export Excel file to sql server database

I uploaded my excel file to sql server database.I need to upload the specific column from the excel file to sql server database.

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by kssaranmca2006 on 01-05-2009, 12:00 AM
Filed under: Database, Database backup, database size, export, Export Import, Database Export, Excel, Excel Data copying