i have a project where i need to update date some people in a program based on an ID. I am given a text file with IDs from one of the programmers.
Every day i need to import this list of IDs
Looks something like
What is the best way for me to to import this into a colum in my local sheet.
Thanks for your help.
I tried to use the importdatasheet, but the first row overwrites my column header at run time.
I am using QT 8.2
Create a script that opens the file, reads a line (store in variable), then use DataTable.Value(x,y) = variable to set the value to a cell in your datatable.
Look up FileSystemObject in the QTP Help file, or search for it here (or search for FSO).
"The last 10% of any software project will take 90% of the budgeted time. The first 90% will take the other 90%"