Read data from csv file in vbscript

Then these four lines will do. If you mean something another or have a problem, let me know that please. Many Thanks for you help!!!

Yes I mean reading it field by field because I then want to populate a table in a database. I am using a. I know it must be simple but I am a newbie and i need to do this urgently! Thank you very much for you help. I see what you are doing. I want to populate this sql server table.

Is there anywhere I can go through each CSV field through the recordset and then insert it into a destination table through another recordset??? By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. Guys I am trying to automate the creation of local users on local servers they are workgroup servers, not in AD and I have written a script to create the user and do all of the necessary tasks as far as that is concerned.

What I would like to do now is have a text CSV file containing information such as Username and Full Name and then have my script read the information from that and create the users accordingly. Please can anyone help me out with how to read from a text CSV file and then pass the information to the script to action?

Password not required for the CSV file Thanks in advance. Thanks for the code. Thanks for all of your help guys, I have written my script and it is working great : "Who is General Failure and what is he doing on my computer? Are the fields fixed length or variable length?

Add a comment. Active Oldest Votes. WriteLine outputString Loop Please note, the code is completely untested and written mostly from memory so is almost certainly not correct but just to give you an idea. Improve this answer. Hans Olsson Hans Olsson Maybe a simple Replace would work. ReadAll objFile. Write strSearchString objFile. Furthermore the old answer should do the job fine.

Sign up or log in Sign up using Google. Banfa 9, Expert Mod 8TB. NET forum Raghu Raghu, thanks for your proposal. I need to learn as well. Raghu, thanks for your proposal. Next I. Thank you, but how about if i would like to grab the data and perform calculation for example 3.

How should i proceed from here? Expand Select Wrap Line Numbers. Post Reply. Visual Basic.