Microsoft Text Driver INNER JOIN

Posted on 2005-02-24
Medium Priority
Last Modified: 2012-05-05
Is it possible to open an INNER JOIN recordset using the Microsoft Text Driver to connect to two text delimited files?  If it is possible can you please explain.

Question by:macaulish
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
1 Comment
LVL 58

Accepted Solution

amit_g earned 2000 total points
ID: 13398918
Yes provided both text files are in the same directory ...

    dim oConn, oRs
    set oConn = Server.CreateObject("ADODB.Connection")
    Call oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\InetPub\wwwroot\Test\;Extended Properties=""text;HDR=No;FMT=Delimited""")

    set oRs = oConn.Execute("select * from Test1.csv T1 inner join Test2.csv T2 on T1.F1 = T2.F1")

Featured Post

Independent Software Vendors: 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

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

800 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