oledb Questions
2
Solved
I'm trying to extract data from a specific named range in Excel with ASP .NET/C#. Here is an exemple of what I'm trying to extract.
What I want is "B", "C", "D" by using the name "RANGE_NAMED". ...
1
Solved
I'm inserting a few rows in a table via OleDB, and select instantly the inserted row.
I can't retrieve the row in this way, i have to wait for approx. 3-5 seconds. And then the inserted row appear...
Grimes asked 11/6, 2013 at 15:33
3
Solved
I'm in need of a functional OleDB data provider for PostgreSQL. It should be similar to the ODBC provider for MySQL. See http://dev.mysql.com/downloads/connector/odbc/5.1.html
Chintz asked 1/12, 2008 at 22:52
2
I'm not sure why this is happening. I've seen the same issue online with little help out there to correct it.
When i run my query inside Access i get different values ranging from 0 - 10 but for s...
Kktp asked 24/5, 2013 at 22:33
3
Solved
I am using C# and OleDb to read data from an excel 2007 file.
Connection string I am using is:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="...
Averi asked 22/2, 2012 at 9:16
2
Solved
If I try to write a datetime to a record in an MS-Access database the easy way, like this
cmd.CommandText = "INSERT INTO [table] ([date]) VALUES (?)";
cmd.Parameters.AddWithValue("?", DateTime.Now...
2
Solved
I'm using Microsoft.ACE.OLEDB.12.0 to connect to Microsoft excel file and fetch data from it. I write my codes in C# language using Visual Studio 2012.
here is my code:
public DataTable getData(st...
1
Solved
I am trying to read a csv file using following code. The file has columns headers also.
Following is the output after loading the file in dataset.
public DataSet LoadCVS(string filePath)
{
Data...
1
Solved
I try to access an Excel file in SSMS. After searching the internet, I could not get it working.
Here is what I did:
My environment:
Windows 7(64bit) SP 1,
Microsoft SQL Server 2008 (SP3) - 10...
Yean asked 15/3, 2013 at 14:19
4
Solved
I am importing excel sheet to DataTable using oledb connection as below.
private static DataTable UploadExcelSheet(string fileName)
{
DataTable uploadDataTable;
using (OleDbConnection objXConn ...
2
Solved
I have an ASP.NET page that needs to push some data to an older program that uses an Access 2003 database for a backend. I have my connection strings all set up to do this (successful to a local co...
4
Solved
2
Solved
I Use Oledb to read an AccessFile(.accdb) to DataSet, I don't know about table names or columns, The regular implementation is:
public void GetAccessDB(string filepath){
this.ConnectionString = "...
2
Solved
I am having issues with ADO.NET 2.0 merging/importing data. I need to update/insert data from one generic table to another table with both tables maintaining an identical schema. The following code...
1
Solved
tl;dr version
I get errors when using OLE DB (SNC10.0) connection managers after a few nights of running, could connections not be properly timing out? Switching to ADO.NET Connection Managers an...
Bagatelle asked 5/12, 2012 at 22:32
1
Solved
1
Solved
I use the Microsoft.ACE.OLEDB.12.0 driver in my C# to read and write to excel files (XLS).
The extended properties for my reader looks like : Excel 8.0;HDR=NO;IMEX=1;
and for writer looks like : Ex...
7
Solved
I can't seem to read a .csv file using the following connection string:
var fileName = string.Format("{0}{1}", AppDomain.CurrentDomain.BaseDirectory, "Uploads\\countrylist.csv");
string connection...
1
Solved
I am on a mission to make a candlestick graph using MSChart in a windows form. I already succeeded to make a 3D bar chart with no problems. But after a long search on the internet, Microsoft's sour...
Biblio asked 19/10, 2012 at 22:15
6
Solved
How can I make sure that a certain OLEDB driver is installed when I start my application? I use ADO from Delphi and would like to display a descriptive error message if the driver is missing. The e...
1
Solved
I have created an Excel Macro in which I have used Microsoft.Jet.OLEDB.4.0 to fire query on Excel work sheets.
It's working perfect on my machine but my client is facing issue with it. (see the at...
2
Solved
I am trying to use C# to read excel file which has intermixed datatype. Below is my connection string
var path = //xls location
var MyConnection = new OleDbConnection("provider=Microsoft.Jet.OLEDB...
Superman asked 30/3, 2012 at 3:31
1
Solved
I have a big deal: I have to connect (I just want to read data, not to write) to my customer's IBM AS/400 (aka iSeries, now IBM i) server...
I think I have all parameters needed (given me by the A...
Larondalarosa asked 27/8, 2012 at 7:55
0
I'm trying to read a file that is encoded in OLE format. It isn't a Microsoft Office/common file format that I'd be able to just find a reader for.
I'm trying to write my own reader - I have the f...
2
I've a Master package where in I'm calling several packages using Execute package task.
Both child and master packages don't have any configuration and are connecting OLEDB (SQL Server) using har...
Kaete asked 11/8, 2012 at 18:46
© 2022 - 2024 — McMap. All rights reserved.