Problem With Virtual Table As Parameter

Hi all,

here is what i have so far

set @fld_name = 'sales_vol'
set @tbl_name = 'tbl_sales'

create @tbl table (val int, rank int identity(1,1))
---
I want to insert values of colum 'sales_vol' into the 'val' of the table 'tbl_sales'

i tried this

execute sp_executesql
n'insert into @t(value) select @fld_name from @tbl_name'

---
sql analyser keeps telling me : "Must declare the variable '@t'."

Can I do this? If not, is there another way?

Thank you.

---
here is a sample data for 'sales_vol'
sales_vol
38
217
10
95
34
7
186
39
81
80
31
67
60
5
41
97
259
14
116
-----