Hi
I have managed to solve this using OriginalGriff's advice and modified the switch statement to completely remove the temp table. Seems to be working as intended...for the minute.
switch (_parknums[i])
{
case 2:
tblBBResults.Load(readMe);
break;
case 3:
tblTHResults.Load(readMe);
break;
case 4:
tblBWResults.Load(readMe);
break;
case 5:
tblWHResults.Load(readMe);
break;
case 6:
tblNHResults.Load(readMe);
break;
case 7:
tblWCResults.Load(readMe);
break;
default:
break;
}
Thank you both for your help it was very much appreciated.
Harry