When I try to do a "put item 1 of global somevariable into global anothervariable" I get the error which states that STTableError Table has no database connection info...
What is STTable?
Using excel to add data from the excel into a global "somevariable" which works fine. This error occurs when I try to do the put statement to get data for one row.
I think it's having a problem parsing your code. You don't need to use the "global" keyword if you declare the variable as global in your script/handler. So try this:
put item 1 of somevariable into anothervariable
STTable is an internal object, which is why I think that the code is being parsed incorrectly.
Please note that you should really submit questions like this to the Eggplant support email address. This is intended as a community discussion area and not a support channel.