Stack Overflow
Stack Overflow

Questions tagged [text-driver]

The Microsoft Text Driver is an ODBC Database Driver that allows access to Comma Separated, Tab Delimited and Fixed Width data in text files.

For more information see the Microsoft Developer Center article 'Text File Driver Programming Considerations'

8 questions
5
votes
2 answers

how can i correctly parse a text file delimited by white space

Below is my sample text file { Here is my schema file [Sample File.txt] ColNameHeader=True Format=TabDelimited CharacterSet=ANSI And here is the code i have so far writen to try and read the above sample file, the data rows read…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
3
votes
1 answer

Is it possible to read csv file using 32 bit Microsoft text driver in 64 bit application

I have a requirement where i need to import some data from CSV file using Microsoft Text Driver. My development environment is:- Windows7 64 bit Office 2007 (32 bit) when i try to open a connection it gives me error: [Microsoft][ODBC Driver Manager]…
CodeGuru
  • 2,722
  • 6
  • 36
  • 52
0
votes
0 answers

Microsoft Access Text Driver - Syntax errors received if spaces are present in CSV source paths

I am using Microsoft Access Text Driver in a SELECT Query to JOIN 2 CSV files located at different paths. There is a space in one of subfolders called "TEST FOLDER" of a csv's source path. If I rename it to "TESTFOLDER" and update my csv path in…
sifar
  • 1,086
  • 1
  • 17
  • 43
0
votes
2 answers

ADO and Microsoft Text Driver - Field Delimiter Problem

I'm using VB6 and ADO together with the Microsoft Text Driver to import data from an ASCII file. The file is comma delimited but it also contains double quotation marks around text data fields. The fields are also fixed width. I'm having a problem…
HK1
  • 11,941
  • 14
  • 64
  • 99
0
votes
1 answer

Microsoft Text Driver or Microsoft.Jet.OLEDB.4.0

In my application i have to read data from a CSV file. I want to use Microsoft Text Driver or Microsoft.Jet.OLEDB.4.0. I am confused between the two. Which one should i opt for?
Sidharth
  • 1,251
  • 1
  • 25
  • 40
0
votes
1 answer

Connection String to use Microsoft Text Driver with a preconfigured data source name

We are currently using the following connection string in a script to read a CSV via the Microsoft Text Driver: myConn.ConnectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=O:\;Extensions=asc,csv,tab,txt;" Instead of specifying the…
slayernoah
  • 4,382
  • 11
  • 42
  • 73
0
votes
1 answer

How to get a row by column name

I am trying to get a column value by name instead of by ordinal. Here is the code I already have: SELECT trim([Workitem Id]) as [Workitem Id1] from 1.csv above is the query rrm.id = oDR["Workitem Id"] == DBNull.Value ? string.Empty : oDR["Workitem…
Luke101
  • 63,072
  • 85
  • 231
  • 359
0
votes
0 answers

Microsoft SQL text driver alternatives

I have tried Microsoft.Jet.OLEDB.4.0 and Microsoft Text Driver and both of these or not standard. I am trying to copy and paste simple sql from our database to these text drivers but i must heavily modify the sql to make it work. I am querying csv…
Luke101
  • 63,072
  • 85
  • 231
  • 359