SQL Server Insert

[Abashai]

How can I insert the results of a view into a table which has already been designed and has extra columns in it?

The problem is the extra columns. I tried
INSERT [view] INTO [table]

I also tried to use update. but with no records in the table it would not work. I also tried insert into but that isn't really practical since I have to drop the table to recreate it.

[drekab]

INSERT INTO [Table] ([Field1], [Field2], ...) VALUES ([Value1], [Value2],...)

For variables:

INSERT INTO [Table] ([Field1], [Field2], ...) VALUES ('" & [Value1] & "', '" & [Value2] & "', '"...)