There are some basic structural issues with you code, but the problem moving data to excel is with the data connectivity toolkit which returns the data as a 2D array of variants. By the way, the only thing inside each variant element is a string. The best long term solution is to dump the DCT and use drivers that handle data rationally.
Short term to fix this basic problem run the 2D variant array into two nested for loops. The outer-most loop will index rows, the inner loop will index columns within each row. Inside the inner loop convert the variant of o a string and run the result back out through the two loop boundaries. You will now have a 2D array of strings.
Pass that array to the the array to spreadsheet string function, write the result to a text file and you're done.
Mike...
