you have to notice one thing. importing a sheet in QTP8.2 and prior you have to loop through the GlobalSheet manulally , while in QTP9.0 this behaviour has been changed and it will iterate through the GlobalSheet automatically as it supposed to (New FIX)
I assume you will wanna use QTP8.2 and prior so please try the below:
Datatable.ImportSheet "C:\TicketMaster\Incoming\sample_pipe_separated.xl s", 1, "Global" 'import XLS to your Global Sheet
For i=1 to DataTable.GetRowCount() ' Loop through the lines
Never new that they actually had that working in V9.0?... it's true... you can learn something new everyday.... thanks chillyhouse.. i honestly thought that would never happen or wouldn't work smoothly in QTP..