i was writting a very complicated sql, if i could use transact sql, it will be much easer, i'm trying to query sql server database in excel vba code, will i be able to use transact sql, i am using querytable and refresh to execute the sql now, would i be able use transact-sql instead of sql? thanks for any tips?