Databases :: Reading Excel Data To SQL Database

Sep 23, 2010

Using C# to develop an application.I need to upload data ( which is in excel) to a sql table.


View 1 Replies

Similar Messages:

Databases :: Reading Data From An Excel Workbook (.xls)

Mar 1, 2011

I have a scenario where I have to read an excel file to dump records in a mysql database. The code generates an exception Sheet1 not found. I have pasted the code below. Please let me know the solution to the exception. I have given the correct read/write/modify settings to my excel file.

if (fileUpload1.PostedFile.FileName.EndsWith(".xls") || fileUpload1.PostedFile.FileName.EndsWith(".XLS"))
string fileName = Server.MapPath(fileUpload1.PostedFile.FileName);
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 8.0";
// Create the connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
// Open connection
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]" , oledbConn);
// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();
// Fill the DataSet from the data extracted from the worksheet.
oleda.Fill(ds, "RestaurantExcelData");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
Response.Write("Data: " + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "");
catch(Exception e1)
// Close connection
Response.Write("File Not Excel (xls||XLS)");

View 2 Replies

Databases :: Reading Data From Excel 2007?

Aug 3, 2010

I am attempting to read data from an uploaded spreadsheet using ACE.OLEDB. The code, which is running fine on dev and test machines for XL2003/2007 reports "Exernal table is not in the expected format" error on connecting on the production server for XL2007 only.The code is

Dim connectionString As String = "provider=Microsoft.Ace.OLEDB.12.0;" _ & "Data Source='" & ImportData.FullName & "';Extended Properties=Excel 12.0;" LogWebActivity.LogThis("Entering POPSUKD, ConStr=" & connectionString, LogWebActivity.LogDetailLevel.DetailAndData) Dim con As New System.Data.OleDb.OleDbConnection(connectionString) LogWebActivity.LogThis("Dimmed con", LogWebActivity.LogDetailLevel.Debugging) Try Dim cmdSelect As New System.Data.OleDb.OleDbCommand("SELECT * FROM [" & WorksheetName & "$]", con) Dim adapter As New System.Data.OleDb.OleDbDataAdapter(cmdSelect) Dim dS As New Data.DataSet LogWebActivity.LogThis(cmdSelect.CommandText, LogWebActivity.LogDetailLevel.Debugging) con.Open() LogWebActivity.LogThis("Opened Connection", LogWebActivity.LogDetailLevel.Debugging) adapter.Fill(dS, WorksheetName) LogWebActivity.LogThis("Filled DataAdapter", LogWebActivity.LogDetailLevel.Debugging) _SKUS = dS.Tables(WorksheetName) LogWebActivity.LogThis("Set SKUS", LogWebActivity.LogDetailLevel.Debugging)

View 1 Replies

Databases :: Page Times Out Reading Excel File?

Mar 31, 2010

I have some code that reads records from an excel file and then imports that data into an sql database. The issue only happens when the excel file has more then 350 rows in it. In the middle of the import it just stops executing and I get directed to the 'Internet Explorer cannot display the webpage' page or just a blank page when using firefox.

I dont get any time out errors or any error at all but still I tried messing around with the script timeout settings but still does the same thing at about the 2 min 30 sec mark.


View 2 Replies

Databases :: Reading Excel File Without Saving To Disk First?

Aug 31, 2010

I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.


Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory. I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.

View 2 Replies

Databases :: Reading Hyperlinked Page In Excel File Using C#?

Nov 19, 2010

I understand how to use a connection string object to read excel sheets. What I don't know is how to follow a hyperlink inside excel, grab matching data from the linked page and return it to my database. Essentially, the spreadsheet has two columns:

Title | Class#

Class# has the hyperlink which links to an internal web site. The connected page has a course description and any pre-required classes that must be taken before you can take this class. This is where I'm rather stumped as I've not had to do this type of thing before.

View 4 Replies

Databases :: Reading And Writing MS Excel (2007) Files?

Mar 4, 2011

Want to create a web based application for reading and writing excel files.

Issue :

1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.

View 1 Replies

Databases :: Reading From Excel File With Warning 'number Stored As Text'

Jun 8, 2010

in my application i have to read from an excel files and check the value of every cell i'm using an OleDb connection to open it and reading but i have this issue if some of the cells in the excel sheet is having this warning when i try to read it returns DBNull ??could any one give me a clue ....knowing that i can not force the user for not having this warning ...i have to solve this within my code .

View 5 Replies

Databases :: Reading From An Excel Spreadsheet - Fields With Numbers Are Showing As DBNull

Nov 8, 2010

My web app is allowing the user to load a column of data from an Excel spreadsheet. For whatever reason, as it parses the data, fields that are just integers are coming up as System.DBNull. (Code in VB.NET but I work with C# as well, so feel free to post C# solutions)


dataRow(0) is System.DBNull when the Excel file has a number in Column A. Here's what the Excel looks like

Column A
123456 and 119655902 come through as DBNull

View 8 Replies

Databases :: Importing Data From Excel (.csv) To Database Table?

Mar 13, 2010

i am developing an appilication using 3.5 with and SqlServer 2005 as backend databse.

in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.

View 1 Replies

Databases :: Exporting Data From Database To Excel Sheet?

Nov 9, 2010

I didn know where to post this query so m posting it here

I am tryin to export the data from d database to an excel sheet m using d following stored procedure for this


BlogAssignment being my database name and Data_Table my table.

Trial.xls is the excel sheet where i am trying to insert the data.

I am getting the follwoing error


View 2 Replies

DataSource Controls :: Reading Excel Files To Store Into Sqlserver Database - OleDbException Was Unhandled By User Code

Feb 1, 2010

i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.


View 1 Replies

Databases :: Import Excel 2.1 Format To SQL Database?

Jul 24, 2010

i have some excel file which export from sybase, but it can only export to Excel ver2.1.then I connect and import to SQL Database. The result is error and prompt cannot read the Excel format.Finally I try use Excel 2003 to open the exce v2.1 and save as 2003 version. Then import again, it can success to import to SQL connection string excel properties = 8.0i tried to change 8.0 to 2.1 or 5.0, the result is still cannot import. how to import v2.1 directly. no need use Excel to open and save again.another question, if I want import more than one excel, how can I import all one time only.

View 2 Replies

Databases :: How To Read Excel Using C# And Store In Oracle Database

Jun 9, 2010

How do I read excel(with many worksheets) using c# and load the data into oracle database?

View 2 Replies

Databases :: Import Excel To Grid And Store It In Database?

Mar 23, 2011

how to import excel file to grid view and that data can be store in database in

View 1 Replies

Databases :: Want To Import Excel Data By Excel Rowindex?

Mar 11, 2011

Is there a way to import an amount of data from an excel sheet using the sheet rowindex, something like: SELECT * FROM [PLAN1$] WHERE ROWINDEX BETWEEN 1 AND 1000?

View 1 Replies

Databases :: Upload Ms Word File And Store It Into Database Then Reading The File?

Jan 12, 2011

i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..

View 5 Replies

Databases :: Reading CSV File From The Fileupload And Then Retrieve The Data?

Mar 4, 2010

1) I need to make reading CSV file from the fileupload and then retrieve the data.

2) I need to load CSV and the 3 columns rise two functions.

Load CSV data and then stored in a database, but I need to save storage space vary according to 3 column.

CSV Example:
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2

Now I need to load the CSV in C # and column 3 to distinguish what the operation is carried out.When the load line in column 3 contain the value 1, so will save the table 'Cats' when the value 2 and is saved in the table "Dogs".(Note: Data are separated ";")

View 4 Replies

Databases :: How To Transfer Data From Excel To Another Excel Using .net

Oct 8, 2010

Can you tranfer the data from Excel to another Excel using 3.5 without saving it to database.

View 1 Replies

Databases :: Read Excel File From 5th Row Onwards - Store All Records Into Database

Mar 18, 2010

I am facing 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.

View 4 Replies

Databases :: Excel Parsing Error - The Microsoft Jet Database Engine Could Not Find The Object

Nov 17, 2010

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.

the code is the exact same as in [URL]

View 2 Replies

Reading An Excel Work Book - OLEDB Or Excel Interop

Mar 22, 2011

I need to read an Excel work book with 2 sheet which have more than 60,000 records. The application is an ASP.Net application so the performance matters.

Which approach should I take? Sohuld I do it using Microsoft.Office.Interop.Excel or should I do it using OLEDB in ADO.Net?

View 3 Replies

Connection String Reading Data From Excel?

May 18, 2010

I am trying to read data from excel file in I have added the connection string to webConfig file:

<add name="xls" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=HPM_DB.xls;Extended Properties=Excel 8.0"/>

But it shows me an errormessage when I run this query:

string query = "Select * from [IO_Definition$]";

IO_Definition is the name of the spreadsheet in my excel file. I also added the excel file to the App_Data folder of the website.

The error is:

The Microsoft Jet database engine could not find the object 'IO_Definition$'. Make sure the object exists and that you spell its name and the path name correctly.

The thing is, when I write the absolute path of the excel file in the connectionString it does work. Is there anyway I can make it work without writing the absolute path?

View 1 Replies

Reading Data From A Non-standard Excel Format?

Feb 26, 2011

I want to read data from an excel sheet which is in non-standard format. I have tried many things but could not find a solution,

View 1 Replies

Web Forms :: Improper Reading Data From Excel

Jan 5, 2013

I have made an application to read data from an excel file and save to database "Access". It's working perfect except one thing that..There are 4 columns in excel file as :

Shop no
owner address
alternate member address
permanent member address

For all fields i have kept same datatype in database as "text". As in above image In Column A "shop no" in some rows there are same shop no with A,B,C classes. Now when I am uploading this excel file it saving all data, but in Column A cells which having only numbers would be saving to database eg: 185, 187, 188. And the cells which has both number and class eg: 185 A, 185 B would be reading as null values.

View 1 Replies

Copyrights 2005-15, All rights reserved