how to parse a text file into data base using VBS

[kalpu]

Hi all,

i have a text file with a line of more than 1000, which contains information about the user name and password etc. i want to write a script to parse my text file into a Data Base using DIAdem. i don't have any work experience in VBS or DIAdem. can any one please guide me on this.

Thanks in advance for your reply.

Thanks,

Shruthi,

[Brad_Turpin]

Hi Shruthi,

Actually, DIAdem doesn't give you any functionality for this task that you don't already have with a VBScript running in the Windows Scripting Host.  You can use the built-in FileSystemObject to open the text file, the Split() command to parse out the values left to right, and the ADO object to open a connection to the data base and insert the new records.

Brad Turpin

DIAdem Product Support Engineer

National Instruments