With an SQLTask it is possible to do a CREATE TABLE on the Excel connection. Is there anyone who knows how to modify the SQLStatement property of this task? I manage to read from it but not to write to it. Am I doing something wrong or isn't it supposed to be writeable from an ActiveX script?
Regards, Hans!