Tagged Questions
0
votes
0answers
20 views
Appending data to one cell in Excel using OleDb
Is there a way to append data to one cell in Excel using OleDb?
For example, let's say I have a cell that has the value "Help me" and I want to append " Stack Overflow" to that cell. How would I do ...
0
votes
0answers
5 views
Oledb not retriving complete data from excel into data set
I am trying to get the data from excel into dataset using OLEDB but I am not getting all the rows in the excel into dataset. I have 243300 rows in the excel sheet but I am getting only 44401 rows as ...
0
votes
0answers
13 views
GetOleDbSchemaTable sometimes runs very slowly
I'm using OleDbConnection.GetOleDbSchemaTable() to get the list of worksheets in an Excel workbook. With some workbooks, the method takes 1 minute or more to complete; with others with the same ...
0
votes
1answer
30 views
Reading Excel files in a locale independent way
I am using the following code to read data from various Excel files:
// IMEX=1 - to force strings on mixed data
// HDR=NO - to process all the available data
// Locale 1033 is en-US. This ...
0
votes
0answers
22 views
Very strange issue to read excel via OLEDB
I got a very strange issue with the following testing code to read excel
const string ConnectStringPattern = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= {0};Extended Properties=\"Excel ...
0
votes
1answer
44 views
How to copy DataTable to Excel File using OLEDB? [duplicate]
I am writing a program send data to excel by using oledb.
I used Update statement like next:
OleDbConnection MyConnection = new OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + ...
0
votes
3answers
101 views
Writing into Excel through C#
This can be a very naive question.
I want to write into into an excel file and each time the insert of data should happen on a new line.
Here is what i have to do in detail:
Create an Excel ...
0
votes
0answers
35 views
Oledb loading blank instead of Excel data in DataGrid
Why am I unable to see any data in my data grid when there is heaps of data in my Excel File.
It's just showing Blank Page instead of data.
My code is
using System;
using System.Data;
using ...
0
votes
1answer
42 views
Importing Excel Data using Oledb
I am using the following code to display the Excel Data into DataGrid using Oledb. But I am getting an error Fill: SelectCommand.Connection property has not been initialized.
Can anybody tell me ...
0
votes
0answers
74 views
Handling excel times imported from excel using Microsoft.ACE.OLEDB C#
I am importing an excel file using C# and JetOLEDb (Microsoft.ACE.OLEDB for excel 2010 and beyond), and I am using the following code:
var fileName = @"C:\myexcel.xlsx";
var ...
3
votes
2answers
151 views
Excel Querytable Refresh only works once
I am adding a ListObject to an Excel 2007 Workbook using VBA. The ListObject is to have a QueryTable behind it, linking to an Access database. The code looks like this:
Dim l As ListObject
Dim c ...
0
votes
0answers
91 views
How can I export a DataTable to excel using OLEDB or ODBC adapter in c#?
Is it possible to export a DataTable object of .net to an excel sheet using an OLEDB or ODBC adapter?
If yes, how?
Selina
0
votes
1answer
310 views
Importing data from Excel to SQL Server database using Microsoft.ACE.OLEDB.12.0
I'm developing an application where I need to import data from Excel to an MS SQL Server database.
I've installed Microsoft Access Database Engine 2010 Redistributable on the MS SQL Server machine as ...
1
vote
1answer
156 views
OleDbConnection in C#
I have written code for inserting data into excel sheet.My code doesn't throw any exception and each time excel file's size get incremented by 1KB. But when I open the sheet it does not show any data.
...
2
votes
3answers
7k views
Using OleDb to insert data into Excel 2007 in C#
I have been researching all day long and cannot find an example of what I want to do. I have used as a base for what I want to do this site:
...
