Hi All
I've been using FileToMemoryTable(myTblControl, myDataSource) perfectly but it doesn't keep
my previous resultSet ie I wanna append resultSet to the same memory table with stringBuild instead
of exporting to xlsx each time then merge into a single table as FileToMemoryTable clear myTblControl
for next same query with different stringBuild's.
Any clue and thx in advance.
ps I am just to program to loop thru by using tableAddline with col1[n]+tab+... but it's clumsy esp. when sqlStmt is formed dynamically.
Cheers
King