Questions about oledbconnection
Read more about oledbconnection
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
VB.NET - Format of the initialization string does not conform to specification starting at index 34
Dim path As String = xlPath
Dim conString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "';Extended Properties='Excel 8.0;HDR=No;IMEX=1;TypeGuessRow...
HanSol23
Votes: 0
Answers: 0
OLEDB connection avoid auto convert on text to int
when run a simple vbs code to read a csv.
Example CSV:
AB,CD
XYZABDER,TLK431
..
with following code
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject(&quo...
user18269031
Votes: 0
Answers: 1
SSIS OLE DB Destination Editor - Create New Table not an option?
I am trying to have upload a CSV file to my SQL Server via SSIS. Previously- like a few months ago- I was able to click 'New' on the destination editor to create a generic table based on the imported ...
mlf
Votes: 0
Answers: 1
Why do my WPF application's OleDbConnection objects crash on opening when running batch?
We have an interactive WPF application on .Net 5.0 for Windows that we now need to be able to launch in batch mode.
I've duly added a test on e.Args (from App.OnStartup()): if e.Args[0] has the expect...
Jean-David Lanz
Votes: 0
Answers: 0