Solved

ODBC text driver

Posted on 2002-05-16
3
352 Views
Last Modified: 2010-08-05
I am currently using Microsoft text driver in VB code to read from a tab, comma delimeted sytle file. This works OK until some entries contain double quotes in which case it strips everything after the quotes. In the default on the PC I am testing the defaults are as follows:
File Type: ANSI
Row delimiter: {CR}{LF}
Text qualifier: Double quote{"}
I have tried using the schema.ini file also but there is still a problem so I need to use the ODBC text drivers. Any sample of code on how to do this would be helpful.
Thanks.
0
Comment
Question by:bcc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7014259
That's was a problem to me to too. If you could access the files before processing, open each on with open statement, save the contents to a variable, replace every instance of double quotes (with Replace funtion) and open the file for output and write back the content of variable to file.
0
 

Author Comment

by:bcc
ID: 7014726
Thanks Richie but that's not really a solution to my problem, is it? If you have already worked out a way to do this I would like to know it please.
0
 
LVL 16

Accepted Solution

by:
Richie_Simonetti earned 50 total points
ID: 7014740
I can access the files before processing, if you cannot do it my advise doesn't help you. I did it in the way i have commented out.
Sorry.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access Search and Replace Using VBA 6 92
VBA filters 2 71
fso.FolderExists("\\server\HiddenFolder$") 4 89
Problem to line 23 74
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question