Questions tagged as 'oledb'

Tagged questions
0
answers

Connection to Database .DBF using C #

I am developing a Windows Form application and I need to connect it to a database with a .DBF extension. Based on this question and esta page I developed the following code: OleDbConnection Conn = new OleDbConnection { ConnectionStri...
asked by 12.06.2018 / 20:35
1
answer

How to obtain the data of an excel with OLEDB Data Provider?

I have a problem because I am trying to read an excel (xls), with the OLEDB, I already install the driver but it does not load the file, this is the error that indicates me. This is my code. try { // CargaMasiva...
asked by 07.05.2018 / 19:21
1
answer

Error importing an excel file into VB.NET

Greetings to all, it turns out that I am doing an importer that consists in uploading data from an Excel file to a table made in SQL Server (In an app made in VB.NET), I am adapting a code according to my needs and when importing the Excel file...
asked by 24.01.2018 / 00:24
0
answers

Help with Data Source OLEDB

Hello, good morning, my colleagues, I am trying to create a connection string through a program. The problem I have is that when I add the string and I tell the application to connect it gives me the following error. It is not a valid file na...
asked by 05.12.2017 / 17:18
1
answer

Error using openrowset

I have a problem regarding openrowset . I am running the following encoding: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Procesos\PRUEBA.xlsx', [Hoja1$]) and I get the following error:    The O...
asked by 05.11.2016 / 00:44
1
answer

"SQL Server" Server Error "DELETE" and "INSERT" from Excel

I have created a procedure that first deletes the records from my table and then imports them from excel. DELETE tabla WHERE columna='dato' INSERT INTO tabla SELEC * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Sourc...
asked by 20.10.2016 / 01:32
1
answer

Read excel with a large number of columns in C #

Hello dear developers, I have a small problem, it turns out that I am reading excel sheets in a console program and I play an excel that has a lot of columns (Until the column ABT) and my excel dataset only reads up the column WZ and I do not kn...
asked by 12.11.2018 / 20:07
1
answer

Error connecting from .net to Oracle

I am setting up a new WS2012R2 server to host applications; the applications are made in .NET 2.0 and are connected to Oracle 10g. The connections are made through OLEDB. On the new server I have already installed the Oracle client and tns...
asked by 08.09.2016 / 20:22