Hey Guys,
Sorry i didn't explain my problem before. Let me shed some light. Basically there were two stages i went through in order to get the module working.
My first problem occured during the installation (error above), to remedy this i uninstalled the module, and hunted for every instance in the ModuleSettings table for the feedback module and in particular "Feedback_Rows", i found there were references to older versions that i had already uninstalled and references to old wrapper modules that i had long since deleted that contained the feedback module.
With all references of the module now deleted i installed the module again and hey presto...installed fine with no SQL error. 
.
Moving on, the second problem i had was the module was sending an email to the administrator but not to the user after the form was submitted. All admin settings were correct i.e. Sendto had the right address and the Send Copy box was ticked, but still no luck. I thought i had exhausted all paths when i decided to investigate my SMTP server configuration (Host Settings > Advanced Settings > SMTP Server Settings).
I have direct access to the SMTP server (through IIS) as well so i verified the server wasn't blocking 'relayed' messages from my web site...all was good. Then i checked that the port was open...again all good. Finally i replaced the mail server address (smtp.domain.co.nz) with "localhost" in the SMTP Server text box and now it all works fine, emails now get sent to both admin and the user.
Hope this helps...i know i have gone round the houses abit but its working now!!
Ben