Questions tagged as 'oledb'

Tagged questions
1
answer

Hide my OLEDB connectionstring in Excel

I need to hide the password or the entire connection string to outsiders who use a certain template in Excel 2010. To create the connection, I follow the following steps in Excel: "Data" tab Option - "From other sources" Option - "Fro...
asked by 28.02.2017 / 22:06
1
answer

OLEDB conection goes down when processing a large number of files

I have a problem with oledb in C # turns out that it is a console that reads files .xlsx of a folder (170 files in total) but when it goes in reading No. 120 it falls and the error is "Unknown" OleDbConnection Econ; Econ = new OleDbConnection(...
asked by 10.09.2018 / 22:57
1
answer

No values specified for some parameters (EXCEL / VB.NET / OLEDB)

Very good community! The following problem I had experienced before when I made modifications (UPDATES) to the excel sheet, but I always found some solution ... but ... not now ... and the funniest thing that I am following to the letter The ste...
asked by 18.09.2016 / 19:59
1
answer

Syntax error INSERT INTO OleDB

I am trying to launch the following code from a button and the error in the image jumps to me: Button code sCmd = "INSERT INTO Vendedores (Password,Grupo) VALUES ('151515',0)" GestionSql.Launch(sCmd) GestionSql.Launch code: (line 5...
asked by 02.05.2018 / 22:08
1
answer

Oledb + excel + HDR = NO. How to make selects?

The thing is that I want to make Selects in Excel, in any possible way, I do not value interop since the sheet is dynamic, one day it can have 340 records, another day 20. What I'm trying to do is something kind: Select count(*) From [Sheet...
asked by 12.12.2017 / 16:49
2
answers

Problem with access and c #

I am running the following code, in the fifth line I get an error:    "The input string does not have the correct format" costo = Convert.ToDouble(textBox8.Text); string fecha = DateTime.Today.ToString("dd/MM/yyyy"); OleDbCommand actualiza...
asked by 14.11.2016 / 21:45
0
answers

Connect .Net Core to DB2 AS400 7.2

I need to connect a .Net Core application with a database on AS400 7.2 server, I tried EF but I have not, I want to do it like in the old days with OLEDB and it seems that it does not work anymore, any ideas? I have followed IBM tutorials but I...
asked by 16.10.2018 / 00:47
0
answers

Know the name of the first table of an excel sheet in VB.NET by OleDB

good afternoon. I'm connecting to an xlsx excel file using OleDB, I wanted to know, in what way can I know the name of the table in the file. That is to say, every day they send me an excel file where the table changes. Then I to do the queri...
asked by 05.09.2018 / 22:10
1
answer

Read Excel in C #

Dear that you have a good day, I am in a problem when I try to read an Excel xlsx format, I have done it before and it had never happened to me before. it turns out that it is a console application and when opening the Oledb connection it falls...
asked by 29.08.2018 / 18:45
0
answers

cross-queries with two OleDbDataAdapters

I am trying to insert records in an Access table using an OleDbDataAdapter. The data to be inserted is previously retrieved from another table in the same Access database with another OleDbDataAdapter, but when I run the Update method of the...
asked by 18.07.2018 / 17:09