oledb
How to get rid of the exception "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" in Win 7
I am running an ASP.NET C# application on .NET 4.0 framework using VS2010 on a Win 7 machine.Within my code I want to link Excel file with \"DataTable\" object. ie I want to access the data within Exc[详细]
2023-03-07 14:51 分类:问答C#, Excel, OleDB, Insert statement not working
I haven\'t found anyone with a similar problem so I\'m asking for help. I wrote a simple program that is supposed to read data from an Excel spreadsheet(A) and after doing some calculations will inser[详细]
2023-03-07 14:20 分类:问答Create Table with a Hyphen in the Name Using Excel ACE OLEDB Connection
Has anyone successfully used a CREATE TABLE statement on an ACE OLEDB connection to an Excel 2007 workbook where the table has a hyphen in the name? What I have at the moment is something like[详细]
2023-03-07 14:04 分类:问答Handle NUL (\0) in C#
I\'m retrieving data from a .xls file using oledb and assigning it to a string开发者_如何学Go variable Values using below line:[详细]
2023-03-06 20:24 分类:问答OLEDB for EXCEL - Drop Table [SheetName$] - Doen't Delete Sheet
I am using drop table [SheetName$] to delete a worksheet from excel. This just clears the data of the sheet but does not delete the sheet.[详细]
2023-03-06 18:31 分类:问答Using OleDB to read excel file in c#?
I am building a program to read excel file into dataGridView. using System; using System.Collections.Generic;[详细]
2023-03-06 18:02 分类:问答Performance in reading Excel File using OpenXML
As of now im reading all version of excel files using oledbreader. i referred a dll for reading Excel 2010 files. but i cannot read some excel 2010 files using oledbreader. so i would like to use open[详细]
2023-03-06 03:21 分类:问答oledb param type question
I am trying to select the text from a text box and pass it in as one of the parameters of an oledb command but this error message occurs;[详细]
2023-03-05 20:05 分类:问答Firebird - How to use embedded server with ODBC / OleDB
I need to connect using ODBC / OleDB to a Firebird database, but without the server, so I want to install the embedded server.[详细]
2023-03-05 17:05 分类:问答How to read a data row from Excel with more than 255 characters
The issue is When I set up the DataSet as shown below, the default reads only 255 characters from the spreadsheet cell and places them into the table.[详细]
2023-03-05 04:56 分类:问答
加载中,请稍侯......