Re: VB Script for Reading from CSV file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"mr_unreliable" <kindlyReplyToNewsgroup@xxxxxxxxxxx> wrote in message
news:edXcGjpjIHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
85.reem@xxxxxxxxx wrote:
I need a script that can read Group Information from a text file
(CSV) and create groups in the AD and then add members (from a CSV) to
these groups.

hi 85.reem, csv files are normally read using fso, (to read
line-by-line), and the "split" function, (to break down
the line into an array of the discrete values being separated
by the commas).

Also read using ADODB:

"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & sFolder &
";Extensions=asc,csv,tab,txt;"

I use it all the time.


Is there something with either fso or the split that is causing
you a problem?

cheers, jw
____________________________________________________________

You got questions? WE GOT ANSWERS!!! ..(but,
no guarantee the answers will be applicable to the questions)



.

Relevant Pages

  • Re: Distribution Groups - export lists and members
    ... In migration ... csv files. ... 22 Exchange servers spread over 20 states. ... Is there a way to export the distribution groups and the members to an ...
    (microsoft.public.windows.server.active_directory)
  • Re: VB Script for Reading from CSV file
    ... and create groups in the AD and then add members (from a CSV) to ... the idea is that we will extract some details from an AD then we need ... Create User Accounts from Information in an Excel Spreadsheet ...
    (microsoft.public.scripting.vbscript)
  • Re: VB Script for Reading from CSV file
    ... and create groups in the AD and then add members (from a CSV) to ... the line into an array of the discrete values being separated ...
    (microsoft.public.scripting.vbscript)
  • I want to have a txt file of all members in AD Distribution group
    ... Is their any way to export all members in AD Distribution Group to a file as ... txt or CSV? ... Best Regards ...
    (microsoft.public.exchange2000.general)
  • Re: Relinking a CSV file using code
    ... Access wouldn't have had;Database if you were linked to a CSV. ... I have 5 CSV files that are linked into the FE. ... >>> Dim tdf As TableDef ...
    (microsoft.public.access.modulesdaovba)