Importing Excel data into SQL existing table

[MarkWest05]

Hi,

I am having a real hard time trying to import excel data into an existing SQL table, using SQL 2005. The wizard appears to only allow me to import into a new table, but that doesn't make much sense. Can anyone help me with this?

 

[rtmpxr]

see

http://support.microsoft.com/kb/321686

to append use
insert into <table> select * from EXCELINK...[<your sheet>]