Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
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

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 …
What we learned in Webroot's webinar on multi-vector protection.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

572 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