Writing only unique records to a txt file

Page 1 of 1

1 Replies - 369 Views - Last Post: 23 February 2011 - 03:31 PM Rate Topic: -----

#1 vicara  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 23-February 11

Writing only unique records to a txt file

Posted 23 February 2011 - 02:02 PM

Ok I'm newbie here.

I'm reading a txt file with several duplicates based on a member_key
field. My output needs only one record for these duplicates.

How can I do this in VB6?

Thank you in advance
Is This A Good Question/Topic? 0
  • +

Replies To: Writing only unique records to a txt file

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: Writing only unique records to a txt file

Posted 23 February 2011 - 03:31 PM

An easy way to do it would be to set up an ADO recordset to read the text file, using select distinct as the SQL. Then use a FileSystemObject stream to write the result to a file.

There are other ways, of course.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1