?
Solved

Use ADO to read Random Files

Posted on 2014-01-27
2
Medium Priority
?
237 Views
Last Modified: 2014-01-28
I know that ADO could be used to read text files (comma delimited or tabbed)

My question is can ADO be used to read Random Files (saved in text form) containing User Defined Types

Usually it is read as follows :

   Dim rec as RandomRecord

   Open "C:\RandomFile.txt For Random As #1 Len = Len(Rec)
   
   nRecords = LOF(1) / Len(Rec)
   
   For i = 1 To nRecords
   
      Get #1, i, Rec

   Next i

Thank you
0
Comment
Question by:rohaya
2 Comments
 
LVL 55

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39814329
0
 

Author Closing Comment

by:rohaya
ID: 39814747
Excellent link. Addresses my question. Thanks.
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Here is why.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

568 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