I need some clarification regarding External data Table. So far I am thinking that using External DataTable means storing it in another folder and renaming the name Default.xls that gets created. Now when my client asked me that is this External or not I am getting a doubt whether what I am doing is right???. I have a folder structure where in I place all the scripts into one folder and data tables into another folder. Now in QTP I attach the data table name by selecting other location. Pl advice me is this the correct method?? Also they asked me whether they can any other database other than excel like Access etc?? This is going beyond my understanding ..:-)
External Datatable is used when u want to Normalize ur data structure.
U Can use DataTable.ImportSheet("Absolute Path - FileName", "SheetName")
and then DataTable.GetSheet("SheetName")
and then u can access any value from that sheet.